ࡱ> qv}  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnoprstuvwxyz{|}~Root Entry F ."ZWorkbook_VBA_PROJECT_CUR" 3pǽMsoDataStore#!3MKHQWW21==23BItem PropertiesO5RZYCXSXBQ==23MItem  .PropertiesCtls VBAM% \p51Թnshusd Ba=  ThisWorkbook=<,8X@"1Calibri1Calibri1Calibri1Calibri1Calibri1Calibri1(  Trebuchet MS1 Calibri1Calibri1Calibri1 Calibri1Calibri1Calibri1Calibri1 Calibri1 Calibri1 Calibri1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1 Calibri1 Calibri1Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-0.00;[Red]0.00"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                       ff + ) , *       P  P         `                          ! a> " !" !  !"       ! @ @ @ @ 1@ @ !"     ( # $  "(X          1 1 !1 1    ""  @@   @  @@  @   @  ! !  !@ @  %@ @ +       ||w1I}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-} 00_)}-}  00_)}-}  00_)}-}  00_)}-}  00_)}-}  00_)}-} 00_)}-} 00_)}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}+ 00_)}-}, 00_)}-}- 00_)}-}. 00_)}-}1 00_)}A}2 a00_)[$ -}A}3 00_)[$ -}A}4 00_)?[$ -}A}5 00_)23[$ -}-}6 00_)}}8 ??v00_)̙[$ -##0.  }A}9 }00_)[$ -}A}: e00_)[$ -}-}A 00_)}}B 00_)[$ -##0.  }}C 00_)[$ -##0.  }x}D00_)[$##  }}E ???00_)[$???## ???  ??? ???}-}F 00_)}-}G 00_)}U}H 00_)[$## }-}I 00_)}A}J 00_)[$}A}K 00_)[$}A}L 00_)[$}-}M 00_)}-}N 00_)}-}P 00_)}-}Q 00_)}A}U 00_)[$}(}V00_)}(}W00_)}-}X 00_)}(}Y 00_)}(}Z 00_)}-}[ 00_)}-}_ 00_)}-}` 00_)}-}a 00_)}-}b 00_)}-}c 00_)}-}d 00_)}-}e 00_)}-}f 00_)}-}g 00_)}A}k 00_)[$}A}l 00_)[$}A}m 00_)[$}A}n 00_)[$}A}o 00_)[$}-}p 00_)}-}q 00_)}A}r 00_)[$}A}s 00_)4[$}-}t 00_)}-}u 00_)}-}v 00_) 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L湸 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ٗ % 60% - Accent3M( 60% - Accent3 23֚ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Excel Built-in Normal 20Excel Built-in Normal 2 21Explanatory TextG5Explanatory Text % 2Good;Good  a%3 Heading 1G Heading 1 I}%O4 Heading 2G Heading 2 I}%?5 Heading 3G Heading 3 I}%236 Heading 49 Heading 4 I}%7( Hyperlink 8InputuInput ̙ ??v% 9 Linked CellK Linked Cell }% :NeutralANeutral  e%3Normal % ;Normal 2< Normal 2 2= Normal 2 3 >Normal 3 ?Normal 4 @Normal 5 ANormal 67Normal 6 % BNoteb Note   CNote 2fNote 2   DNote 2 2jNote 2 2   EOutputwOutput  ???%????????? ???F$Percent GTitle1Title I}% HTotalMTotal %OOI Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`JRead MeInvestor Details i/Error5Sheet3&Country_State_District_Mapping2 AndamanandNicobarIslands;' AndhraPradesh; * ArunachalPradesh; Assam; Bihar;% Chandigarh:& Chhattisgarh;! Country;&DadarNagarHaveli: % DamanandDiu;  Delhi;  Goa; ! Gujarat; ! Haryana;) HimachalPradesh;  India;$+Investment_Litigation:,8InvestmentLitigatio):,;,,. InvestmentLitigation;,,2 InvestmentLtg):,;,,( InvestmentType; '') JammuandKashmir;# Jharkhand;# Karnataka;  Kerala; ! Lakshadweep:' MadhyaPradesh;2% Maharashtra;#! Manipur; # Meghalaya;! Mizoram;NA:+" Nagaland;   Orissa;! Pondicherry:  Punjab;# Rajasthan;! sf;-- sfusa;-->$ shares_from_unpaind_suspense_account;--Asharesfromunpaidsuspenseaccountz-{--$ sharesfusa;--  Sikkim; ss;-- sss;--# TamilNadu; # Telangana; !!! Tripura;""% Uttarakhand; $$& UttarPradesh;K##$ WestBengal;%%fvf`@'&@  8-OM $" [߸rK@= [߸rK $Xr/xVKTQ7+'-T,UIA"RP"Ōe)tvm $M.[ZNeJxVFwܙKazs=f<iRL@ӹ\~cc ~nRK|`nً4!|z|CI=Tc0(bN(.ZpU~FSR)ʲ?BACЌmۜ(Ku!B@.4=[#Z%咧dha'fhq<|35O7J90,y&pw1m;C<_1ى=!=3?NeRr ħ|O'}3ُ&2Q &fD.'̠Ù[t j*?@W(h@-QE$v5tYnUYR Qpؙ\&"w' ^}V~h nÜ-LpNi-ATlgB^5p{i*Jj&脅(.jΒTLP,q/4 #Ț! B.h4sPylyK鹹 )֯’U0U.Z9i\\Vr^ {^7뀨kV9EP>^qMWu:Ge֗R:OMWbUo4ew0r} zmJSި~ȇGWs\WO${^ʜg֑:@+\\kZjy|h%߿S=Ay<}X¸_~u%!wzY*YrwnD)ədfߟn\{\¿^P }nlj^(Y~C^-'w<[FMlפy:V oƥ^,sxc<)94! o t(up_ڂlׄ&>_CW <XAA `B_<*=௃$gm ̭yӗu) >"O_b2WW@=O_b2WWƈ $(r/xVOA~-Pz %1H1֐@R lDTrRYAa0,D8KL#j? #=TOfhlб zr90SePL*Os.[V`irqTb˪dYΎ3z9%K1+7;#ףO ·̑-P2e r2-ywc,)y\/Fw5>W`{\az𛒅Am-dziq!HT}c?H`@mAyXzcarB߻ʢ]]d^'xnglWkM͡*鏀_4@檹mpn3/siJ zA3 A@@   G[Read the following instructions carefully before proceeding to enter the Investor Details: Important Note >Steps to follow to fill details in the 'Investor Details' tab. Enable MacrosY It is important that you Enable Macro using following instructions : a) Excel 2000 and 2003: Tools-->Macro-->Security-->Select 'Low'-->OK b) Excel 2007: Office Button-->Excel Options-->Trust Center-->Trust Center Settings--Macro Settings-->Enable all Macros-->OK Pl Note : Close the Excel Sheet and re-open it after enabling Macro to start.  Enter the CIN  Add Investor DetailsSave the Excel file If you have multiple excels for the same CIN and SRN; use the below nomenclature: (ABC_1.xls, ABC_2.xls,ABC_3.xls ...) where ABC represents the CIN of the Company Upload the Excel fileCountry Indian StatesAndaman and Nicobar IslandsAndhra PradeshArunachal PradeshAssamBihar Chandigarh ChhattisgarhDadar Nagar Haveli Daman and DiuDelhiGoaGujaratHaryanaHimachal PradeshJammu and Kashmir Jharkhand KarnatakaKerala LakshadweepMadhya Pradesh MaharashtraManipur MeghalayaMizoramNagalandOrissa PondicherryPunjab RajasthanSikkim Tamil Nadu TelanganaTripura Uttar Pradesh Uttarakhand West BengalInvestment TypeNAINDIAAndaman Islands AnantapurAnjawBarpetaArariaBastarDadar & Nagar HaveliDaman Central Delhi North Goa AhmedabadAmbalaBilaspurAnantnagBokaroBagalkot Alappuzha Alirajpur Ahmednagar BishnupurEast Garo HillsAizawlDimapurAngulAmritsarAjmer East SikkimAriyalurAdilabadDhalaiAgraAlmoraBankura(Amount for unclaimed and unpaid dividend AFGHANISTANNicobar IslandsChittoor Changlang Bongaigaon AurangabadDiu South GoaAmreliBhiwaniChambaBadgamChatraBangalore Rural ErnakulamAnuppurAkola ChurachandpurEast Khasi HillsChamphaiKiphire Boudh (Bauda)BarnalaAlwar West SikkimChennai North TripuraAligarh Bageshwar BardhamanAmount for matured deposits ALAND ISLANDS East Godavari Dibang ValleyCacharBanka Dantewada East DelhiAnand FaridabadHamirpurBaramulaDeogharBangalore UrbanIdukki AshoknagarAmravatiChandel Jaintia HillsKolasibKohimaBhadrakBathindaBanswara North Sikkim Coimbatore Hyderabad South Tripura AllahabadChamoliBirbhumAmount for matured debenturesALBANIAGuntur East KamengDarrang BegusaraiDhamtari New Delhi Banas Kantha FatehabadKangraDodaDhanbadBelgaumKollamBalaghat Imphal EastRi-Bhoi LawngtlaiLonglengBolangir (Balangir)FaridkotBaran South Sikkim Cuddalore Karimnagar West TripuraAmbedkar Nagar Champawat Cooch Behar+Amount for application money due for refundALGERIAKadapa East SiangDhemaji BhagalpurDurg North DelhiBharuchGurgaonKinnaurJammuDumkaBellaryKannurBarwaniBeed Imphal WestSouth Garo HillsLunglei Mokokchung Baleswar (Balasore)Fatehgarh SahibBarmer DharmapuriKhammamAuraiyaDehradun DarjeelingInterest on matured debenturesAMERICAN SAMOAKrishna Kurung KumeyDhubriBhojpurJanjgir-Champa North East BhavnagarHissarKuluKargilGarhwaBidar KasaragodBetulBhandaraSenapatiThe West Khasi HillsMamitMonBargarh (Baragarh)Fazilka BharatpurDindigul MahbubnagarAzamgarhHaridwarEast MidnaporeInterest on matured depositsANDORRAKurnoolLohit DibrugarhBuxarJashpur North WestDahodJhajjarLahaul and SpitiKathuaGiridihBijapurKottayamBhindBuldhana TamenglongWest Garo HillsSaihaPerenCuttackFirozpurBhilwaraErodeMedakBadaunNainitalHooghly,Interest on application money due for refundANGOLAPrakasamLower Dibang ValleyGoalpara DarbhangaKanker South Delhi GandhinagarJindMandiKupwaraGoddaChamarajanagar KozhikodeBhopal ChandrapurThoubalSerchhipPhekDebagarh (Deogarh) GurdaspurBikaner KanchipuramNalgondaBagpat Pauri GarhwalHowrah&Redemption amount of preference sharesANGUILLANellore Papum PareGolaghatEast ChamparanKawardhaSouth West DelhiJamnagarKaithalShimlaLehGumla Chikballapur Malappuram BurhanpurDhuleUkhrulTuensang Dhenkanal HoshiarpurBundi Kanyakumari NizamabadBahraich Pithoragarh Jalpaiguri#Sales proceed for fractional shares ANTARCTICA SrikakulamTawang HailakandiGayaKorba West DelhiJunagadhKarnalSirmaurPoonch Hazaribagh ChikmagalurPalakkad Chhatarpur GadchiroliWokhaGajapati Jalandhar ChittorgarhKarur Rangareddi Balarampur Rudra PrayagKolkataANTIGUA AND BARBUDAVishakhapatnamTirapJorhat GopalganjKoriyaKachchh KurukshetraSolanPulwamaJamtara ChitradurgaPathanamthitta ChhindwaraGondia ZunhebotoGanjam KapurthalaChuru KrishnagiriWarangalBallia Tehri GarhwalMalda ARGENTINA Vizianagaram Upper SiangKamrupJamui MahasamundKheda MahendragarhUnaRajauriKodermaDakshina KannadaThrissurDamohHingoli JagatsinghpurLudhianaDausaMaduraiBandaUdham Singh Nagar MurshidabadARMENIA West GodavariUpper Subansiri Karbi Anglong JehanabadRaigarhMahesanaMewatSrinagarLatehar DavanagereThiruvananthapuramDatiaJalgaonJajapur (Jajpur)MansaDholpur Nagapattinam Barabanki UttarkashiNadiaARUBA West Kameng KarimganjKaimurRaipurNarmada PanchkulaUdhampur LohardagaDharwadDewasJalna JharsugudaMoga DungarpurNamakkalBareillyNorth 24 Parganas AUSTRALIA West Siang KokrajharKatihar RajnandgaonNavsariPanipatPakurGadagDharKolhapur KalahandiMuktsar Hanumangarh PerambalurBastiNorth DinajpurAUSTRIA LakhimpurKhagariaSurguja Panch MahalsRewariPalamuGulbargaDindoriLatur Kandhamal PathankotJaipur PudukkottaiBhimnagar (Sambhal)Purulia AZERBAIJANMarigaon KishanganjPatanRohtakPashchim SinghbhumHassanGuna Mumbai City KendraparaPatiala JaisalmerRamanathapuramBijnorSouth 24 ParganasBAHAMASNagaon Lakhisarai PorbandarSirsaPurba SinghbhumHaveriGwaliorMumbai SuburbanKendujhar (Keonjhar)RupnagarJalorSalem BulandshahrSouth DinajpurBAHRAINNalbari MadhepuraRajkotSonepatRanchiKodaguHardaNagpurKhordha!Sahibzada Ajit Singh Nagar-MohaliJhalawar Sivaganga ChandauliWest Midnapore BANGLADESHNorth Cachar Hills Madhubani Sabar Kantha Yamuna Nagar SahibganjKolar HoshangabadNandedKoraputSangrur Jhunjhunu Thanjavur!Chhatrapati Shahuji Maharaj NagarBARBADOSSibsagarMungerSurat SeraikelaKoppalIndore Nandurbar MalkangiriShahid Bhagat Singh NagarJodhpurTheni ChitrakootBELARUSSonitpur Muzaffarpur SurendranagarSimdegaMandyaJabalpurNashik MayurbhanjKarauli The NilgirisDeoriaBELGIUMTinsukiaNalanda The DangsMysoreJhabua Osmanabad NabarangpurKotaThirupurEtahBELIZENawadaVadodaraRaichurKatniParbhaniNayagarhNagaur ThiruvallurEtawahBENINPatnaValsad RamanagaraKhandwaPuneNuapadaPaliThiruvannamalaiFaizabadBERMUDAPurniaShimogaKhargoneRaigadPuri Pratapgarh Thiruvarur FarrukhabadBHUTANRohtasTumkurMandla RatnagiriRayagada Rajsamand ThoothukudiFatehpurBOLIVIASaharsaUdupiMandsaurSangli SambalpurSawai MadhopurTiruchirapalli FirozabadBOSNIA AND HERZEGOVINA SamastipurUttara KannadaMorenaSataraSubarnapur (Sonepur)Sikar TirunelveliGautam Buddha NagarBOTSWANA< SaranYadgir Narsinghpur SindhudurgSundargarh (Sundergarh)SirohiVellore Ghaziabad BOUVET ISLAND SheikhpuraNeemuchSolapurSri Ganganagar ViluppuramGhazipurBRAZILSheoharPannaThaneTonk VirudhunagarGondaBRITISH INDIAN OCEAN TERRITORY SitamarhiRaisenWardhaUdaipur GorakhpurBRUNEI DARUSSALAMSiwanRajgarhWashimBULGARIASupaulRatlamYavatmalHardoi BURKINA FASOVaishaliRewaJalaunBURUNDIWest ChamparanSagarJaunpurCAMBODIASatnaJhansiCAMEROONSehoreJyotiba Phule NagarCANADASeoniKannauj CAPE VERDEShahdol Kanpur DehatCAYMAN ISLANDSShajapur Kanpur NagarCENTRAL AFRICAN REPUBLICSheopurKanshiram NagarCHADShivpuri KaushambiCHILESidhi KushinagarCHINA SingrauliLakhimpur KheriCHRISTMAS ISLAND TikamgarhLalitpurCOCOS (KEELING) ISLANDSUjjainLucknowCOLOMBIAUmariaMahamaya NagarCOMOROSVidisha MaharajganjCONGOMahoba COOK ISLANDSMainpuri COSTA RICAMathura COTE DIVOIREMauCROATIAMeerutCUBAMirzapurCYPRUS MoradabadCZECH REPUBLIC Muzaffarnagar$DEMOCRATIC PEOPLES REPUBLIC OF KOREAPanchsheel Nagar (Hapur)DENMARKPilibhitDJIBOUTIPrabuddha Nagar (Shamli)DOMINICADOMINICAN REPUBLIC RaebareliECUADORRampurEGYPT Saharanpur EL SALVADORSant Kabir NagarEQUATORIAL GUINEASant Ravidas NagarERITREA ShahjahanpurESTONIA ShravastiETHIOPIASiddharthnagarFALKLAND ISLANDS (MALVINAS)Sitapur FAROE ISLANDS SonbhadraFEDERATED STATES OF MICRONESIA SultanpurFIJIUnnaoFINLANDVaranasiFRANCE FRENCH GUIANAFRENCH POLYNESIAFRENCH SOUTHERN TERRITORIESGABONGAMBIAGEORGIAGERMANYGHANA GIBRALTARGREECE GREENLANDGRENADA GUADELOUPEGUAM GUATEMALAGUERNSEYGUINEA GUINEA-BISSAUGUYANAHAITI!HEARD ISLAND AND MCDONALD ISLANDSHOLY SEE (VATICAN CITY STATE)HONDURAS HONG KONGHUNGARYICELAND INDONESIAIRAQIRELANDISLAMIC REPUBLIC OF IRAN ISLE OF MANISRAELITALYJAMAICAJAPANJERSEYJORDAN KAZAKHSTANKENYAKIRIBATIKOREAKUWAIT KYRGYZSTANLAO PEOPLES DEMOCRATIC REPUBLICLATVIALEBANONLESOTHOLIBERIALIBYAN ARAB JAMAHIRIYA LIECHTENSTEIN LITHUANIA LUXEMBOURGMACAO MADAGASCARMALAWIMALAYSIAMALDIVESMALIMALTAMARSHALL ISLANDS MARTINIQUE MAURITANIA MAURITIUSMAYOTTEMEXICOMONACOMONGOLIA MONTENEGRO MONTSERRATMOROCCO MOZAMBIQUEMYANMARNAMIBIANAURUNEPAL NETHERLANDSNETHERLANDS ANTILLES NEW CALEDONIA NEW ZEALAND NICARAGUANIGERNIGERIANIUENORFOLK ISLANDNORTHERN MARIANA ISLANDSNORWAYOMANPAKISTANPALAUPALESTINIAN TERRITORYPANAMAPAPUA NEW GUINEAPARAGUAYPERU PHILIPPINESPITCAIRNPOLANDPORTUGAL PUERTO RICOQATARREPUBLIC OF MOLDOVAREUNIONROMANIARUSSIAN FEDERATIONRWANDASAINT BARTHELEMY SAINT HELENASAINT KITTS AND NEVIS SAINT LUCIA SAINT MARTINSAINT PIERRE AND MIQUELON SAINT VINCENT AND THE GRENADINESSAMOA SAN MARINOSAO TOME AND PRINCIPE SAUDI ARABIASENEGALSERBIASERBIA AND MONTENEGRO SEYCHELLES SIERRA LEONE SINGAPORESLOVAKIASLOVENIASOLOMON ISLANDSSOMALIA SOUTH AFRICA,SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDSSPAIN SRI LANKASUDANSURINAMESVALBARD AND JAN MAYEN SWAZILANDSWEDEN SWITZERLANDSYRIAN ARAB REPUBLICTAIWAN TAJIKISTANTHAILAND THE DEMOCRATIC REPUBLIC OF CONGO)THE FORMER YUGOSLAV REPUBLIC OF MACEDONIA TIMOR-LESTETOGOTOKELAUTONGATRINIDAD AND TOBAGOTUNISIATURKEY TURKMENISTANTURKS AND CAICOS ISLANDSTUVALUUGANDAUKRAINEUNITED ARAB EMIRATESUNITED KINGDOMUNITED REPUBLIC OF TANZANIA$UNITED STATES MINOR OUTLYING ISLANDSUNITED STATES OF AMERICAURUGUAY UZBEKISTANVANUATU VENEZUELAVIET NAMVIRGIN ISLANDSWALLIS AND FUTUNAWESTERN SAHARAYEMENZAMBIAZIMBABWECIN Company NameNominal value of sharesInvestor First NameInvestor Middle NameInvestor Last NameFather/Husband First NameFather/Husband Middle NameFather/Husband Last NameAddressStateDistrictPin Code Folio NumberDP Id-Client Id-Account NumberNumber of shares (i)Install the pre-requisite softwares to proceed. The path for the same is as follows: MCA Portal >> Investor Services >> IEPF >> IEPF Application >> Prerequisite Software (ii) Upload the excel file in the format xls only (iii) Do not make any changes in the excel format/sheet name. Also do not delete any tab/sheet in the file PLEASE NOTE: 1) Kindly ensure that Summation of amounts in the excel(s) should be equal to that in IEPF Form, else your excel shall get rejected. 2) Kindly ensure that AGM Date in the excel(s) should be same as in IEPF Form, else your excel shall get rejected.   (i) Enter the CIN in the excel (cell B2) (ii) Click on "Prefill" button (iii) Company Name will be automatically filled on click of prefill button . User need not enter it. 9 B ] z U Path to upload the excel file is HOME -> IEPF SERVICES -> Upload Investor details. -Actual Date of transfer to IEPF (DD-MON-YYYY) Note: This sheet is applicable for uploading the particulars related to the shares transferred to Investor Education and Protection Fund. Make sure that the details are in accordance with the information already provided in e-form IEPF-4.PAN Aadhar Number Nominee NameJoint Holder NameRemarks6Is the Investment (amount/shares) under any litigation3Is the shares transfer from unpaid suspense accountInvestment LitigationYESNOYES $shares from unpaind suspense account (i) Fill in the required details in Columns A to P for Investor Details (row 15 onwards) (ii) Follow the below mentioned validations for filling in the details. First Name -> Mandatory if 'Last Name' is blank and Length should be less or equal to 35 characters. Middle Name -> Length should be less or equal to 35 characters. Investor Last Name -> Mandatory if 'First Name' is blank and Length should be less or equal to 35 characters. Father/Husband First Name -> Mandatory if 'Father/Husband Last Name' is blank and Length should be less or equal to 35 characters. Father/Husband Middle Name -> Length should be less or equal to 35 characters. Father/Husband Last Name -> Mandatory if 'Father/Husband First Name' is blank and Length should be less or equal to 35 characters. Address -> Mandatory and Length should be less or equal to 300 characters. Country -> Mandatory and Select value from the dropdown. State -> Mandatory and Select value from the dropdown. (1)If the Country is  INDIA , the state should Indian state (2)If the Country is other than INDIA state should be  NA . District -> Select value from the dropdown. (1)If th<2e Country is  INDIA , the district should be Indian districts corresponding to the State selected in dropdown. (2)If the Country is other than INDIA district will be  NA Pin code -> Alphanumeric and Length should be eithe 6 or 12 dight Folio Number -> Mandatory and Length should be less than or equal to 20 characters. Investment Type -> Select value from the dropdown. Amount Due -> Mandatory and should be greater than zero. Date of Event-> should be in DD-MON-YYYY format where 'MON' implies first three letters of Month. PAN -> Alphanumeric and Should be equal to 10 characters Date of Birth -> Should be in DD-MON-YYYY format where 'MON' implies first three letters of Month. Aadhar Number -> Should be exactly 12 digits. Nominee Name -> Length should be less than or equal to 100 characters. Joint Holder Name -> Length should be less than or equal to 100 characters. Remarks -> Length should be less than or equal to 100 characters. Is the Investment (amount / shares )under any litigation. -> Mandatory and select value from Dropdown Is the shares transfer from unpaid suspense account (Yes/No) -> Mandatory and select value from Dropdown (iii) Click on "Validate" button (iii) Details of the Errors will be shown in "Error" Sheet. *Make sure that Error sheet contains no errors. % H `  Date of Birth(DD-MON-YYYY) L74899DL1960GOI00333551Թ (INDIA) LIMITEDSURENDERKUMARJAINRS>E-42 2ND FLOOR GALI NO 8 SASHI GARDEN MAYUR VIHAR PH-I 1100911100910003676 17-NOV-2023 AGXPJ0071DGAURAVJAINNULLASHOKDNYNOBAKATEHARIBHAU(PIMPLE SOUDAGR, TALUKA - HAVELI 41103741103712023500-00099099-NA AQQPK4584KLATIKAPVARMAPRADEEPFA/403, MALLIKARJUN C.H.S., LINK ROAD, KANDERPADA, DAHISAR (W), 40006840006812028900-00107929-NA AEXPV6775JVARUN MAHESHWARISHYAMSUNDER&FLAT NO 18 MURKUTE VASTI BANER 11007811007812029900-01583386-NA ALVPM9316KSAMIRGADKARIKIRISHNA(48 ANUPAM NAGAR NEAR UNIVERSITY 47401147401112033200-02909695-NA AKBPG2504QABHISHEK CHAKRABORTY SIDDHARTHA^E 1/5 20/1 BIDHAN NAGAR ROAD ULTADANGA MAIN RD ULTADANDA MAIN RD NR BHIVUTI BHUSAN MKT 70006770006712036000-02184968-NA AOSPC1432JADITICHAKRABORTYRAVIBHASINSHOM PRAKASHBHASINC-5, OLD GANDHI NAGAR 20100120100112036800-00004531-NA AGFPB6774R RAMANUJAMBALAJIC PAZHAVERI6A 7 CHANAKYAPURI SOCIETY SUSSEN TARSALI ROAD . 39000939000912047200-10431316-NA AHCPR4079HROYMATHEWSCHACKONA/12, RAMKRISHNA CO HSG SCTY PORNIMA COMPOUND MURBAD ROAD, KALYAN WEST 42130142130112047600-00181899-NA ABXPM5152BAMITGAGRANIKAILASHCHANDRA 2-P-17 R.C. VYAS COLONY 31100131100112058300-00003819-NA APYPG0792E KHURSHEEDANOORZEAULHASAN7A-219 GALI NO-4 A-BLOCK KABIR NAGAR JYOTI NAGAR 110032110032IN300118-11238665-NA AGNPN5852EPRAMILASETHROOPKISHOREKAPOORS E 39 SWAMI BAGH 282005282005IN300214-13808819-NA BFYPS0260LSATGURSARANSETHMSHINYMUKUNDAN/OLD NO NEW NO 39 GANAPATHYAPPAN STREET 641030641030IN300214-17068107-NA DDAPS8570K PREMALATHAVCHINNATHAMBI@BLOCK NO C-5 FLOT NO-6 C-5/6 SAF GAMES VILLAGE KOYAMBEDU 636107636107IN300394-11737948-NA ARCPP1609HMEENAGUPTASIYARAMA1001/74 SHALIMAR GUARDEN EXT NEAR SEC 8 INDRA NGR LUCKNOW 226016226016IN300513-14863200-NA ALVPG4440LSILVASOPHIASILUVAINADARFB/506 NEHA APT L B S MARG BHANDUP W MUMBAI NEAR KRISHNA CINEMA 400078400078IN300513-19318688-NA AAQPS4060ADILIPSAWANT PANDURANGMAHADEV7362/20 ASMITA CHSL SEC/3 CHARKOP KANDIWALI WEST 400067400067IN300513-21153937-NA AZTPS6482LHARJITKAURSURJITSINGH1353 SARASWATI BHANDAR COLONY GANDHI NAGAR 110031110031IN300966-10078004-NA AJDPK6141LLALITA SHREEVALLABHBAHETIMA 27 BABULNATH BLDG 4 TH FLOOR 60 FEET RD SUDAMA NAGAR BHAYANDAR WEST 401101401101IN301604-11056294-NA AUAPB2566NMANOJKT CHANDAPILLAINKARIPPASERRY VEEDU NEAR HEALTH CENTRE, PAYATTAMKUNNAM, DHONI, PALAKKAD 678009678009IN301637-10048452-NA ANVPM6563ASURAPA RAJUNAIDUNARAYANASURYAMURTHYUD NO.79-7-17A, PATA SOMALAMMA GUDI VEEDHI, SAI RAKSHA APPT.101,SYAMALA NAGAR, 533101533101IN301983-10821967-NA ADJPT6177BTAPASHSONTOSH@R - 520/D, NEW QUARTERS, TYPE - III, N.S.C.B.I. AIRPORT, 700052700052IN302105-10542957-NA ACLPC9901BDHARAMPAULAHUJA MANGHURAM!HN 52, SECTOR 15 PART I, 122001122001IN302269-10402478-NA AAAPA0418Q SAMADNOORKHANNHKHAN'974/A LOCO NORTH RAILWAY COLONY 208004208004IN302822-10044535-NA AJBPK2377EPREETHIRAJPALKAMAL=NO 546 1 NALLPULLPA GARDEN SHANTINAGAR LANGFORD ROAD 560027560027IN303077-10112915-NA AQAPP7172J X 4\\L]]?^^(_s_*`u`aZab] b c[ |c cB d dF e fW vf f:sgg*Ihh+Piibjj[kk 6ll+mvmnYnnG}oo1Vpp2q}qrersastftu]uvLcvv-wxwxKx$ySyzCzzY{{o|| E}t}'~HG+Z O - y 2 x 6e Ņ \ N^܈ !ȏ <H  @L  Ua Zf+,8ccB    dMbP?_*+% &ffffff?'ffffff?(?)?MR\\HYDHTCPRNTSRV02\HYDHTCB18F01tC odXXLetterDINU"0 D  0SMTJ IUPH"xjAM4Q"a` jźM&XXnkKLnۃR^}x+H}gd$?Ő,|v|)^E*RX Ikew][~*_^^a&j#~X>S&&)/M;~a$d)'*3ӽm(w{. )6>@B|UeM)=w_ӫj%m-sK _a]A ҉}EYD _ o&,AF ݪM?ky/n?|4EU ;X'K[nSVA= sx.e%*XaZL #3J˯Vkv%g;KV˭Gzl~޿.u>:b.:}-   F&]W$~z" dXX333333?333333?&<3cU} U'X} U|X} X,  [  xd P< hh Y Z ij \ ] Y ] Y ] ^ ] \ ZxPH0(  >@ Sheet4gg  "  dMbP?_*+%  &ffffff?'ffffff?(?)?MSend To OneNote 16@/ odXXLetterGIS4DINU"$SMTJ{3EE39114-30B4-45a4-A109-19D4A40FCC22}RESDLLUniresDLLPaperSizeLETTEROrientationPORTRAITResolutionDPI600ColorMode24bppV4DM" dXX333333?333333?&<3cU} qa} qa} a} qa} a} U_} _} U_} d} a} a} e} U`} qa} U _} qa} a} U_} _}  _} U_} _} U _} _} U _"P P P,P P P P PP                             sssssssssssss Q kl Q m no c b p ppq~ r@r b b b b b R R R R R R R R R  R  T  R  R  R S T T T T T T T T Tg u u u u u u u u2 u t u u t ur@vr@ u u ttt u t u u~ f@ u u u u u u u u2 u  t u t u uo@vo@ u u ttttt u u u u u u tt u u2 u  t u t u uY@vY@ u u ttttt u u u t u u u u u u2 u t u t u uy@vy@ u u ttttt u u u t u u u u u u2 u t u t u uY@vY@ u u ttttt u u ut u ut u u u2 u/ t  u t  u uN@vN@ u u ttt ut u uf u u u u u u u u2 u- t  u t  u uY@vY@ u uttttt u u ut u u u u u u2 u t  u t  u u@v@ u uttttt u u ut u ut u u u2 u  t  u t  u uI@vI@ u uttttt u u ut u u u u u  u2 u( t  u  t  u  u@v@ u u ttttt u u u t u ut u u u2 u t  u t  u u$@v$@ u uttttt u u ut u u u u u u2 u- t  u t  u uI@vI@ u u ttt ut u u ut u  u! tt u" u2 u* t  u# t  u$ u@v@ u u%ttttt u u ut u& u' u( u) u* u2 u* t  u+ t  u, uI@vI@ u u-ttttt u u u.t u/ u0 u1 u/ u2 u2 u- t  u3 t  u4 u^@v^@ u u5ttttt u u u6t u7 u8t u9 u: u2 u  t  u; t  u< u@v@ u u=ttttt u u u> u u? u@ uA u? uB u2 u  t  uC t  uD u4@v4@ u uEttttt u u uFt uG uHt uI uJ u2 u t  uK t  uL u$@v$@ u uMttttt u u uN uO uP uOt uP uQ u2 u  t  uR t  uS u$@v$@ u uTttttt u u uUt u uV uW uX uY u2 u t  uZ t  u[ uI@vI@ u u\ttttt u u uW u] u^ u_ u` ua ub u2 u  t  uc t  ud u0@v0@ u uettttt u u uft u ugt u uh u2 u/ t  ui t  uj uu@vu@ u ukttttt u u ul um un uot un up u2 u t  uq t  ur ui@vi@ u usttttt u uD"l0Z @ Z2  &         !  ut t uu u uv uw ux u2 u- t uy t uz uY@vY@ u u{ ttttt u u !u| !uV !u} !u~ !tt !u !u2 !u! t ! u! t ! u! u@v@ !u !u!ttttt  !"#$%&'()*+,./0123456789:;<=>?2iwDocumentLibraryFormDocumentLibraryFormDocumentLibraryForm !u !u6 :# ,"#(    l A ?@AA?CommandButton10 ]` m0 6$hdForms.CommandButton.1H"  s HA ?@CommandButton2"ÊPK!4xP[Content_Types].xmlN0EH-J@5XIbl$M$J7Xܹc/W;kc|QV^icRs28;_5W>`bv}A${JQBcD۪һ.y1=(| P7X\A?IED$2Ml:*&cMuH7Ð`ҽ0V!WD.CTBEѦy(7=AVKT^n,Ͱ:3qyl3?4?PK!0?2 _rels/.rels 0nzUd$dۛ xeof1Fw AN{c]t- 838zG 6Y}S~XRHz \v:'L /ؓ\JO4_L7 T ϐ}YM[#B,#1цhEU Z~-m^PK!clipboard/drawings/drawing1.xmlN0H4l)Dh) Z A XK-o8qKBgx/J;/(kfjۊ}qJkFrO/Pl'A%T YY#cF_cGfHV2+$S 4 Y94 =xDJV$} o}K~鈨+ӠE4KlUX7Nx4d]x#1-~9:I>R_NbuXCJ# ~)~ŦQ *'OrDE忼,`1.SۇRk!e4G1bCWapK}'ĕ\=sS'>8X6eT+˧_ :nQ$ O6!C Gf !iaoPK!SRa*clipboard/drawings/_rels/drawing1.xml.relsJ1 Prكlg/"UmS⾽ս8K qU\jHb`(\o|6Gk6p f+~T#b G:eSz[MԯN&I(!}y{ڃC"$qǫ^x>8xwFK xL:ޜH]>ɘc1$"rwPdcmM@2OH Ϧ\DX&*ZimGfCP#~{:>1ɴ#пų<9G#@yaAǫ?omH1bma)q.:hl e\9?Z]<j7Ye޽Jp%nNuL ^6Vc KFwk9x~pjx :A=L9)|(Ȇ<)ժ\}.@'d}Ƃb-o\xbI\"iYH&}+@^='?ѣ?Z^Ņ/ϯ?Fٓ_}wK[DfjN|+F! }:[sp]:ﮀQ>: L7rκ\:UhŬLvNhf{!qc8V8 1QH?XwRǯ\B(bZ;XC#˼fݻYEBA`V0ǍLᨌGXeJ/RA8Oekn UiwV/43HKv@AZ'KɤYYצZY_=lY}NgÙ+Ωŋtvaזٓ% iv1)4>(A|VӴ|ga~xEF疒caQ3LFiA_N˝P&JT/~PK !#@4FFclipboard/media/image1.pngPNG  IHDR.¸sRGBgAMA a pHYs&?IDATx^q0@QT6 M(rf"X78 I,Q6qض-pAP!BB *"T D@P!BBf16&>;E}W>GnM3皏I/!V&.+⯒8[(L jɇZ)qD_ߪ]8\ R&>G\:? !/91boD;6ۚ q]l4%M|S<#Ĩ ʭ]8!x5D譨_wѷSOhԇ?LbBmLxSosֶM)ѷ;.P9!**"T D@P!BB *"TCNGz "qȲC܏IENDB`PK-!4xP[Content_Types].xmlPK-!0?2 E_rels/.relsPK-!/clipboard/drawings/drawing1.xmlPK-!SRa*'clipboard/drawings/_rels/drawing1.xml.relsPK-!Z=Aclipboard/theme/theme1.xmlPK- !#@4FFG clipboard/media/image1.pngPKZk]` m1 6$PjxForms.CommandButton.1HH<"  s HA ?@CommandButton3"ÊPK!4xP[Content_Types].xmlN0EH-J@5XIbl$M$J7Xܹc/W;kc|QV^icRs28;_5W>`bv}A${JQBcD۪һ.y1=(| P7X\A?IED$2Ml:*&cMuH7Ð`ҽ0V!WD.CTBEѦy(7=AVKT^n,Ͱ:3qyl3?4?PK!0?2 _rels/.rels 0nzUd$dۛ xeof1Fw AN{c]t- 838zG 6Y}S~XRHz \v:'L /ؓ\JO4_L7 T ϐ}YM[#B,#1цhEU Z~-m^PK!clipboard/drawings/drawing1.xmlN0H4l)Dh) Z A XK-o8qKBgx/J;/(kfjۊ}qJkFrO/Pl'A%T YY#cF_cGfHV2+$S 4 Y94 =xDJV$} o}K~鈨+ӠE4KlUX7Nx4d]x#1-~9:I>R_NbuXCJ# ~)~ŦQ *'OrDE忼,`1.SۇRk!e4G1bCWapK}'ĕ\=sS'>8X6eT+˧_ :nQ$ O6!C Gf !iaoPK!SRa*clipboard/drawings/_rels/drawing1.xml.relsJ1 Prكlg/"UmS⾽ս8K qU\jHb`(\o|6Gk6p f+~T#b G:eSz[MԯN&I(!}y{ڃC"$qǫ^x>8xwFK xL:ޜH]>ɘc1$"rwPdcmM@2OH Ϧ\DX&*ZimGfCP#~{:>1ɴ#пų<9G#@yaAǫ?omH1bma)q.:hl e\9?Z]<j7Ye޽Jp%nNuL ^6Vc KFwk9x~pjx :A=L9)|(Ȇ<)ժ\}.@'d}Ƃb-o\xbI\"iYH&}+@^='?ѣ?Z^Ņ/ϯ?Fٓ_}wK[DfjN|+F! }:[sp]:ﮀQ>: L7rκ\:UhŬLvNhf{!qc8V8 1QH?XwRǯ\B(bZ;XC#˼fݻYEBA`V0ǍLᨌGXeJ/RA8Oekn UiwV/43HKv@AZ'KɤYYצZY_=lY}NgÙ+Ωŋtvaזٓ% iv1)4>(A|VӴ|ga~xEF疒caQ3LFiA_N˝P&JT/~PK !#@4FFclipboard/media/image1.pngPNG  IHDR.¸sRGBgAMA a pHYs&?IDATx^q0@QT6 M(rf"X78 I,Q6qض-pAP!BB *"T D@P!BBf16&>;E}W>GnM3皏I/!V&.+⯒8[(L jɇZ)qD_ߪ]8\ R&>G\:? !/91boD;6ۚ q]l4%M|S<#Ĩ ʭ]8!x5D譨_wѷSOhԇ?LbBmLxSosֶM)ѷ;.P9!**"T D@P!BB *"TCNGz "qȲC܏IENDB`PK-!4xP[Content_Types].xmlPK-!0?2 E_rels/.relsPK-!/clipboard/drawings/drawing1.xmlPK-!SRa*'clipboard/drawings/_rels/drawing1.xml.relsPK-!Z=Aclipboard/theme/theme1.xmlPK- !#@4FFG clipboard/media/image1.pngPKNK]` m1 6$jForms.CommandButton.1H>@mm  U * M  Invalid CINPlease enter a valid CINFoomc  Input Errpr.You cannot enter Name more than 35 characters.# f  Input Error1You cannot enter Address more than 300 characters#, k  Invalid Input5Please select a valid Country from the drop-down list##   Invalid Input3Please select a valid State from the drop-down list0lINDIA  , NAB"   Invalid Input6Please select a valid District from the drop-down listL Bx" R  Inout ErrorPlease enter a valid Pin Codet th  ~  Input ErrorIFolio Number should be alphanumeric and less than or equal 20 characters.B | Input ErrorhDP Id-Client Id-Account Number should be alphanumeric and of length less than or equal to 60 characters.<   Input ErrorNPlease enter valid Number of Shares. Values can range from (1-999999999999999) e to3&k C   Input ErrorVPlease enter the proper Nominal Value of Shares ranging from 0.01 to 9999999999999.99 o{Gz? ?0B j  Input Error5Please enter the Date of Event in the required format f.0  h  Input Error3Please enter the Date of AGM in the required format    Invalid Input3Please select a valid State from the drop-down list0lINDIA  , NAB" W Invalid Value!Please select from Drop down liste #,wn + ue#,Pl R( Invalid PAN PAN should contain 10 characterst F( Invalid DateInvalid date formatch er X(Invalid Aadhar#Aadhar should contain 12 characters bx Invalid Name/Nominee Name should be less than 100 charactersdlx Invalid Name9Joint Holder Name should contain less than 100 charactersd]Invalid Remarks*Remarks should be less than 100 characterschacQ Invalid selectionplease select from drop downchacC( Invalid DateInvalid date formatomro Sheet1gg@  4  dMbP?_*+% &ffffff?'ffffff?(?)?M2WebEx Document LoaderTC odZZLetterGISUDINU"TJjSMTJ"dZZ333333?333333?&<3cU} UPH0 0(   >@ Sheet2gg  0.;(t^&~  dMbP?_*+% &ffffff?'ffffff?(?)?M2WebEx Document LoaderTC odZZLetterGISUDINU"TJjSMTJ"dZZ333333?333333?&<3cU} q1M} M} UM} UM} M} UM}  M} M} M} M} M} M} M} M} M} UM} UM} M} U M} M} qM} M} M}  M}  M} qM}  M} M} M} q M} M} !!U M} "" M} ##U M} $$qM} %%M} &&U M} ''+M} (*U M} ++UM} ,,qM} --"M} .U M.. .8.8.8.8.8.8.8.  .  .  .  .  . . . * * * * * * * * * * * * * * * *  J J J J K K K K K K K K K K K K K K K K K K K K! K" K# K$ K% K& K' K( K) K* !K+ "K, #K- $K. %K/&J 'U0(J~ )L@*J +J1 ,M -M N2 N N3 N4 N5 N6 N7 N N8  N9  N:  N;  N<  N= N> N? N@ NA NB NC N1 ND NE NF NG NH NI NJ N1 NK NL NM  NN !NO "NP #NQ $NR %NS&N 'VT (NO) +M1 ,M -M NU N NV NW NX NY NZN N? N  N[  N  N\  N] N^ N_ N` Na Nb NcN Nd Ne Nf Ng Nh Ni NjN Nk Nl Nm  Nn !N "No #Np $Nq %Nr&N 'Vs (NN) ,M -M Nt NN Nu Nv Nw NxN Ny  NN  Nz N  N{ N| N} N~ N N NN N N N N N N NN N N N  N !N "N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N NZ N N N N NN N N N  N !N "N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N N N N N N NN N NN  N !N"N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N N N N N N NN N NN  N !N"N #N $N %N&N 'V (NN) N NN N N N NN N  NN  N N  N N N N N N NN N N N N N N NN N NN  N !N"N #N $N %N&N 'V (NN) N NN N  N  N  N N N   NN  N N  N N N N N N NN N N NN N N NN N NN  N !N:"N #N  $N! %N"&N 'W# (NN) N$ N N N% N& N' N( N N) NN N* N N+ N, N- N. N/ N0 N1 N N2 N3 N4 NN N5 N6 N N7 N8 N N9 !NT "N #N; $N< %N= &N 'W> (NN) N? N N N@ NA NB NC N ND NN NE N NF NG NH NI NJ NK NL N NM NN NNN NO NP N NQ NR N NS !Nl "N #NU $NV %NW &NNNN) NX N N NY NZ N[ N\ N N] NNNN N^ N_ N` Na Nb Nc Nd N Ne Nf NNN Ng Nh N Ni Nj N Nk "N #Nm $Nn %No &NNNN) Np N N Nq Nr Ns Nt N Nu NN  N Nv Nw Nx Ny Nz N{ N| N N} N~ NNNN N N N N N N !NN" #N $N %N &NNNN) N N N N N N N N N NNNN N N N N N N N N N N NNNN N N N N N N !NN" #N $N %N &NNNN) N N NN N N NN N NNNN  N NN N N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NN N N NN N NNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NN N NNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$N %N&NNNN) N N NNN N NNNNNNN  N N NN N N NN N NNNNN NN N NN  N !NN" #N$NNNNNN) N  N NNN N  N NNNNNN  N  NNN N  N NN N NNNNN NN N NN  N !NN" #N$NNNNNN) N N! NNN N NNNNNNN  N NNN N N NN N NNNNN N NN NN  N  !NN" #N!$NNNNNN) N" N" NNN N# N$NNNNNN  N%NNNN N& NN N' N(NNNN N) NN N*N  N+ !NN" #N,$NNNNNN) N- N#NNNN N.NNNNNN  N/NNNN N0 NN N1 N2NNNN N3 NN N4N  N5 !NN" #N6$NNNNNN) N7 N$NNNN N8NNNNNN  N9NNNN N: NN N; N<NNNN N= NN N>N  N? !NN" #N@$NNNNNN) NA N%NNNN NBNNNNNNNNNNN NC NN ND NENNNN NF NN NGN  NH !NN" #NI$NNNNNN) NJ N&NNNN NKNNNNNNNNNNN NL NN NM NNNNNN NO NN NPN  NQ !NN" #NR$NNNNNN) NS N'NNNN NTNNNNNNNNNNN NU NN NV NWNNNN NX NN NYN  NZ !NN" #N[$NNNNNN) N\ N(NNNN N]NNNNNNNNNNN N^ NN N_ N`NNNN Na NN NbN  Nc !NN" #Nd$NNNNNN) Ne N)NNNN NfNNNNNNNNNNN Ng NN Nh NiNNNN Nj NN NkN  Nl !NN" #Nm$NNNNNN) Nn N*NNNN No"NNNNNNNNNNNNNN Np NqNNNNNNN NrN  Ns !NN" #Nt$NNNNNN)D26lxdF rrr^RH<00 * !* "* #* $* %* &* '* (* )* ** +* ,* -* .* /* 0* 1* 2* 3* 4* 5* 6* 7* 8* 9* :* ;* <* =* >* ?*  Nu N+ NNNN Nv" NNNNNNNNNNNNNN Nw Nx NNNNNNN Ny N Nz !NN" #N{ $NNNNNN) !N| !N,!NNNN !N}"!NNNNNNNNNNNNNN !N~ !N!NNNNNNN !N!NNNN" !#N!$NNNNNN) "N "N-"NNNN "N""NNNNNNNNNNNNNN "N "N"NNNNNNNNNNNN" "#N}"$NNNNNN) #N #N.#NNNN #N"#NNNNNNNNNNNNNN #N #N#NNNNNNNNNNNN" ##N#$NNNNNN) $N $N/$NNNN $N"$NNNNNNNNNNNNNN $N $NNNNNNNNNNNNN" $#N$$NNNNNN) %N%NNNNN %N"%NNNNNNNNNNNNNN %N %NNNNNNNNNNNNN" %#N%$NNNNNN) &N,&NNNNNNNNNNNNNNNNNNN &N &NNNNNNNNNNNNN" &#N&$NNNNNN) 'N,'NNNNNNNNNNNNNNNNNNN 'N 'NNNNNNNNNNNNN" '#N'$NNNNNN) (N,(NNNNNNNNNNNNNNNNNNN (N (NNNNNNNNNNNNN" (#N($NNNNNN) )N,)NNNNNNNNNNNNNNNNNNN )N )NNNNNNNNNNNNN" )#N)$NNNNNN) *N,*NNNNNNNNNNNNNNNNNNN *N *NNNNNNNNNNNNN" *#N*$NNNNNN) +N,+NNNNNNNNNNNNNNNNNNN +N +NNNNNNNNNNNNN" +#N+$NNNNNN) ,N,,NNNNNNNNNNNNNNNNNNN ,N ,NNNNNNNNNNNNN" ,#N,$NNNNNN) -N,-NNNNNNNNNNNNNNNNNNN -N -NNNNNNNNNNNNN" -#N-$NNNNNN) .N,.NNNNNNNNNNNNNNNNNNN .N .NNNNNNNNNNNNN" .#N.$NNNNNN) /N,/NNNNNNNNNNNNNNNNNNN /N /NNNNNNNNNNNNN" /#N/$NNNNNN) 0N,0NNNNNNNNNNNNNNNNNNN 0N 0NNNNNNNNNNNNN" 0#N0$NNNNNN) 1N,1NNNNNNNNNNNNNNNNNNN 1N 1NNNNNNNNNNNNN" 1#N1$NNNNNN) 2N,2NNNNNNNNNNNNNNNNNNN 2N 2NNNNNNNNNNNNN" 2#N2$NNNNNN) 3NH3NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 3#N3$NNNNNN) 4NH4NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 4#N4$NNNNNN) 5NH5NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 5#N5$NNNNNN) 6NH6NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 6#N6$NNNNNN) 7NH7NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 7#N7$NNNNNN) 8NH8NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 8#N8$NNNNNN) 9NH9NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" 9#N9$NNNNNN) :NH:NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" :#N:$NNNNNN) ;NH;NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" ;#N;$NNNNNN) <NH<NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" <#N<$NNNNNN) =NH=NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" =#N=$NNNNNN) >NH>NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" >#NG>$NNNNNN) ?NH?NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" ?#N?$NNNNNN)Dl~~~~~~~~~~~~@* A* B* C* D* E* F* G* H* I* J* K* L* M* N* O* P* Q* R* S* T* U* V* W* X* Y* Z* [* \* ]* ^* _*  @NH@NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" @#N@$NNNNNN) ANHANNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" A#NA$NNNNNN) BNHBNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" B#NB$NNNNNN) CNHCNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" C#NC$NNNNNN) DNHDNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" D#ND$NNNNNN) ENHENNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" E#NE$NNNNNN) FNHFNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" F#NF$NNNNNN) GNHGNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" G#NG$NNNNNN) HNHHNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" H#NH$NNNNNN) INHINNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" I#NI$NNNNNN) JNHJNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" J#NJ$NNNNNN) KNHKNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN" K#NK$NNNNNN) LNVLNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) MNVMNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NNVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ONVONNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) PNVPNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) QNVQNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) RNVRNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) SNVSNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) TNVTNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) UNVUNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) VNVVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) WNVWNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) XNVXNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) YNVYNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ZNVZNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) [NV[NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) \NV\NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ]NV]NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ^NV^NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) _NV_NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dl~~~~~~~~~~~~hhhhhhhhhhhhhhhhhhh`* a* b* c* d* e* f* g* h* i* j* k* l* m* n* o* p* q* r* s* t* u* v* w* x* y* z* {* |* }* ~* *  `NV`NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) aNVaNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) bNVbNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) cNVcNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) dNVdNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) eNVeNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) fNVfNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) gNVgNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) hNVhNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) iNViNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) jN VjNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) kN VkNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) lN VlNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) mN VmNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) nN VnNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) oNVoNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) pNVpNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) qNVqNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) rNVrNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) sNVsNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) tNVtNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) uNVuNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) vNVvNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) wNVwNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) xNVxNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) yNVyNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) zNVzNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) {NV{NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) |NV|NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) }NV}NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) ~NV~NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *  NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N!VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N"VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N#VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N$VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N%VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N&VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N'VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N(VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N)VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N*VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N+VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N,VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N-VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N.VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N/VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N0VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N1VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N2VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N3VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N4VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N5VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N6VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N7VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N8VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N9VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N:VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N;VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N<VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N=VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N>VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *  N?VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N@VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NAVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NBVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NCVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NDVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NEVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NFVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NGVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NHVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NIVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NJVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NKVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NLVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NMVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NNVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NOVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NPVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NQVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NRVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NSVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NTVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NUVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NWVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NXVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NYVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NZVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N[VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N\VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N]VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N^VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *  N_VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N`VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NaVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NbVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NcVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NdVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NeVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NfVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NgVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NhVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NiVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NjVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NkVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NlVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NmVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NnVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NoVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NpVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NqVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NrVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NsVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NtVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NuVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NvVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NwVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NxVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NyVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NzVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N{VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N|VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N}VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) N~VNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)Dlhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh* * * * * * * * * * * * * * * * * * * * * * *  NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN) NVNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN)2$ hhhhhhhhhhhhhhhhhhhhhhPH@0(  >$@j52,,,U  Sheet3gg  3  dMbP?_*+% &ffffff?'ffffff?(?)?M2WebEx Document LoaderTC odZZLetterGISUDINU"TJjSMTJ"dZZ333333?333333?&<3UPHP0(  >@ Sheet5ggD ?- This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision. ns:ds="http://schemas.openxmlformats.org/officeDocument/2006/customXml">'f#xThisWorkbookSheet1-w __SRP_4___SRP_5rKME (SLSS<N0{00020819-0000-0000-C000-000000000046}@(%H@0V^xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2p U&cT gB݆ Fl=8EMEndM rU HyQY 14YA0` t<7:T%d:h%x$ x dd)xd8<$ xd4XrU @$`\n|#<l_E{C6{ F{@H_ x{@H_ l_E{C6{ME(SLSS6"N0{00020820-0000-0000-C000-000000000046} ,` \h@% %4 % @@x@`\pV^$*\Rffff*0>676af2ba4" X ` QWorksheets("Investor Details").Protect Password:="pass", UserInterfaceOnly:=FalsepassSheet3$.B@0oxp2Attribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub Works_ActivA () ' s("Inve$r Details").Protect Password:="p", UserInterfOnly:=M+o)$(?EndN rU X774YA0` 0   4XrU @$`\n__SRP_8 8__SRP_9gSheet4Sheet5 K;#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}x ,h@%@@pV^" X"` QWorksheets("Investor Details").Protect Password:="pass", UserInterfaceOnly:=FalsepassRead Me$.B@0xoph8Attribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub Works_ActivA () ' s("Inve$r Details").Protect Password:="p", UserInterfOnly:=M+)Read Me$( ?End N 'V#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0V^xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU $Module1/]__SRP_2:__SRP_3_VBA_PROJECT(*\R1*#33b*\R1*#10d*\R1*#101*\R0*#f*\R0*#14*\R0*#1*\R1*#65*\R1*#98*\R1*#42*\R1*#90*\R0*#2*\R0*#13*\R0*#9*\R0*#12   (08@HPX`hpx   "       ( 0 8 @ H P X ` h p x         y||xMEH@(<<> i ei row i Err@\ ror!`TA@`L H InB@0x  `ailE  p`k ``yi0$.iPtiialC@\ ell)`Tvest`LpHO p  `0%`oks(`.xls`PInve  `fk >>iInveii8t@\ MA`ZTMPp*Seells.RanX x P`  iiB@i@ pass `p`k /iii@\  `D`kH Hih ii@\  x`GPk _i ihH@'Msi row@\ p 0`J`k viWIfiunteir (c@\ n `M`kp iiietai@\  `P`k( iH ihi Det@\  X`S`k ii  i@\ Inve `X]4k i$ii @\ `ZTPX '@ @@  x `  ##iiiiIN@ Inve`Z$'stor Det X`j@k %%ii ij @\ Stop `Hs`k i iiBlan@\ want `0mPkP IIipletiiiX @\ @ `0vPk iv(iH i@\  8 `0yPk .iiimber@\ 1 or !`0|`kx !Fip i%iStop@\   "`o0 "!!^iPipusbaii8i:  r<@>@B( @Hx@L @R, @V4 @\h@@`H@fT@j\@pXh@tx @8pXX 0@PP 8 Xh`8(8P x pHx0xXPId-C"h##x""#$" #0"#<>@BDJLN@vl mber@"\  "PRTVXZ\F)H"H^`bdjn|ld@xL @z< r`".rp@"8 r@4 @#$ @# @8# Inve@P# $@# @ Det@ @# @ @ ("ve@ $ @($ Fo@| $%%%$%.", rCo@(%p @@%` Fo@\ tNo@X%L Inve@p%< $@%, Fo@% @ @% $@O $(&% @& @ Det% (() )))))*(&(('@'p'&'&`t'&Inve^\ls  @X'H @(8 Det@4 @'$ @' Inve@' @' Ltgt@' @* ate@( @0( H@(* @` @b @dt h@fd @hT @jD @@l4 @n8$ @pH( '>@rP 'D@th 'L@v`( 'R@x 'X@zx( 'F@|( '`@~8) 'x@P) 'n@h) Er@)t 'r@)d B@*@@*T @X*D etai@p*4 @*$ vest@* !@* @* @+ %@+ nter@0+ pass@`+ or D@H+ @x+ @+ refi@+t @+d In@+T B@0@+D 8@,4 'r@8,$ B@*@ , &@P, '@, @h, @, In@, B@0@, leas@, @- e@, sent@(-t  .@X-d eet@@-T ase @p-D @-4 pass@-$ or D@- @- 8@- esto@. heet@0. ).Un@. @H. Det@x. Ms@`. 6Ac@. ialC@.t ell)@.d vest@.T @/D @.4 p@ /$ @ stor@8/ (@P/ esto@h/ @/ Det@ 12P00h0(1180@1@0t ngeS@0d A15:@0T Inve@0D ~@4 @0$ $@ @x1 @ @P1 h1(1.@1 In1P1ails$@1 @ 11@`(21@ @1 @ P12`43X3(3232`z 32+@@3h '@p3X nt V@3H t@38 @04( Stop@$ X@3 @3 olCo@4 unte@4 r = @ 10))@H4 @x4 @ @ 8@6655505h5H5@l  DetX505$.p@5d @5T @P @5@ @p60 @(6 @ @X6 @05 @ @6 @6 @ h989X7997:hP9x8877X7(:p7@l 7X7 7 @0 @8 pr.@8 87#@(8 $@88#'@P8 INh8(8(@ @:P8($@8 @ @8 @8 8@9 Det@ 9 @ @9 @ St@ @t 7 @9d '@9T @D @4 @P$ .Do @ ws f9no.  tP:P8Z 8[= H@==@`@x@0@@<P;;h;`=;@;@l (;;' .r  @;X @;H @D @;4 $@;$ @< @; $@(< @< mber@= 1 or@X< r La@p< anda@< @> p @< r$@< @< @= e@ @ 8;Bin@ col@| usba0= "*02e)@$H=l Fie@&\ @=L r@=< %@>, r@ > @8> @P> $@h> @> mber@> 10 o@> or @> '@? @> r@(?| %@X?l r@@?\ @p?L @?< $@?, @? @? Erro@? @@ D@ r or@@ @ @( @, @. x=>@FH^JNR@4;| @6l x@VXZ\P< BxA CD DAXBABxAAA@l AxAB.rF@AL @B< @8 @(B( @@B @D @B @ @ C @ @ @B CB @ DB @8C @PCx @hCh @CX @CH @C8 @C( @C @ @B @(D @@D @XD @pD @ @JpB @ @D B-FFGHhFE`FEEEE@l EE.rR@FX @FH @D @0F4 @HF$ @G @F @E @PG @ @ @F @G @ G @8G @ @hG @ @JxF @p @G` `I@IJJ IHHIHhHHH@l HhH.r@HX @IH @D @I4 @0I$ @J @xI @ @8J @ @ @I @I @J @ J @ @PJ @ @J`I @p @hJ` @6P LhKLMLKHLKhKKK@l KhK.rV@KX @LH @D @L4 @0L$ @M @xL @ @8M @ @ @L @L @M @ M @ @PM @ @J`L @p @hM` xOPNOPpON0ONPNNhN@l xNPN.rX@NX @NH @D @O4 @O$ @hP @`O @ @ P @ @ @O @O @O @P @ @8P @ @JHO @p @PP` `Rh8QxRhS(HRQRQ8QpQPQ@l `Q8Q.rZ@QX @QH @D @Q4 @R$ @PS @HR @ @S @ @ @R @R @R @R @ @ S @ @J0R @p @8S` @HU `UPVxUpTUT TXT8T@l HT T.r\@TX @TH @D @T4 @T$ @8V @0U @ @U @ T @ @U @U @U @U @ @V @ @JU @p @ V` WW0XWYxXXWWXWW@W W@l 0WW.Hr>@pW\ @WL @XH @HX8 @<( @X @> @xX @X @ @hY @B @ @X @X @ @D @Y| @ Yx @8Yt @PYp @l @Y\ @L @J`X< @Y, [H[[[@]P\\\Z[ZhZZZ@l ZhZ.Hr@@Z\ @0[L @`[H @[8 @<( @x[ @> @[ @\ @ @h\ @B @LhZ @ @ \ @8\ @ @NXp @]` @PxP @\L @\H @\D @\@ @< @, @J[ @(] ( _]P_`a8_`a`^^0^h_]b^@l  ^]_@^0 .r@x^, @( @^ @^ @` @_ @ @_ @ @ @ @_ _h_@x `_@_h @_X @`H _@(`8 @@`( @X` @p` @` @` @` @a @` @a @0a @ @Hax @h @xad @a` @a\ @aX @T @J^D @a4 H^J` H cb dxf ecc(cdbbb@l bb0d.rN@@cD @Xc4 @0 @pc @c @`f @c @0 @hd @ @ @@d Xdd@ f@d@d| @dl @d\ @dL @d< @d, @e @(e @@e @Xe @pe @e @e @e @ @e @f @f @0f @ @Jcx @h @HfX @d&@@ghh0iiHig hgh@gxgXg@ l hg@gh.r^@gL @g< @8 @g( @h @i @Ph @( @h @ @ @h hh @ jh @i @ix @h @hX @`iT @xiP @iL @iH @D @J8h4 @$ @i h2@klllkm(lkk kjjj@l jj.r`@8kX @PkH @D @hk4 @k$ @m @k @ @l @ @ @ @@l @Xl @pl @l @ @ @l @p @ ` @P @k@ @o@rsrpom0sPp(rpr nn8nmsm@l mm."*@PnX @hnH @D @n4 @n$ @o @n @ @Xo @ @ @$ @n @o @&o @ot @od @oT @pD @0p4 @p$ @Hp @xp @`p @p @p @p @p @q @p @ q @Pqt @8qd @hqT @qD @q4 @q$ @q @q @q @ @r @ @( @, @.n @r @r @r @r @ @(op @` nr02b@XrP u(usvXu8ttPts tt@l ts. rd@htX @tH @D @t4 @t$ @v @t @ @@u @ @ @u @u @t @u @u @u @ @ @Jpup @` ywHxy((x ww8wvwv@l vv.r@PwX @hwH @D @w4 @w$ @x @w @ @x @ @ @@x @Xx @px @x @ @x @ @Jw @p @x` @zhP zy{||({ zz8zyzy@l yy.r@PzX @hzH @D @z4 @z$ @{ @z @ @{ @ @ @@{ @X{ @p{ @{ @ @{ @ @Jz @p @{` @xP }~x(~ }}8}|}|@l ||.rj@P}X @h}H @D @}4 @}$ @~ @} @ @~ @ @| @@~ @X~ @p~ @~ @ @~ @ @J} @p @~` hx0P8P@ l .Hrl@ \ @L @H @8 @<( @Ȁ @>p @( @@ @ @0 @ @ @X @p @ @ @| @Ёx @t @p @l @\ @HL @< @J, @` X(X@H00hH@ l X0.rH@D @ȃ4 @0 @ @ @0 @@ @ @؄ @ @ @ Ȅ@ `@x @h @ X @8H @P8 @h( @ @ @ @ȅ @ @ @ @( @@ @X @px @h @pX @T @ІP @L @H @D @J(4 @$ @ B8P@h`xH(@l 8.rP@X @H @D @4 @؈$ @( @  @ @ @ @ @ @ @ @ȉ @ @ @ @J @p @` u##aV^$*\Rffff*0;676af2aa*\R1*#222     7 ;  4U04Uh  0F+2A8@ H&+X2A    ;      $+02AX$+rGHP 2AX B   V(7 0  <H&9C $X0J  ,((7X &:(7 &:"  8@ 0H(7x4F)    (  0  8 2A@ x B            ( 8 H X h x             ( .0 ` x     ^ L( 6R 8X   ,(( X  ` ,(p   ,(   ,(0 8,(Hx ,( ,( ,( P>[X,( )2R  ,(@  px ,(     ,(     %( HX ` "h p  V    Ib821P       B .f  (08 B @ HPX` h  Rp"X     (^p(p &P     (^x(( &P      (^0bX &P  ( 0  @ (^P(^x8(8@&PHp      (^(^8&P       fS x  &P     2$&#(P X&#h &#  &#   06;@x   J   8&#Hp x  6;E %0: @ H P p&# &# &#( 0&#@hp D;        "T @  0P  p 0!(H!$>h!!jS!" "("&P0"X" h"x"  ;"S"(#8#@#&PH#p# ##   #jS#$ $($&P0$X$ h$ x$  $jS$$%%&P%@% P% `% h%  dSp% %% % &P%  & 0&@&H& P& X& h'x' ' '' ' B ' 5'5'  N' ( F(8i0(  h( x( f^( (( ) &M) 0) @) P) X) h)x) ) )) ) B ) 5)5)  N) * "K*F8* 6iX*  *  %* 8i* 6 * 0+ ^8+ ++ + &M, (, 8,H, bP, ^, `-p- x- &M- - -- 2- .^ ....&M./ /0/ 8/ @/ P/`/ h/ x// //B/ ///// (m/(k0(m00(mX0(k0(m0(k0(k0(k 1(kH1(kp1(k1(k1(k1(k2(k82(k`2(k2(k2(k2(k3(k(3(kP3(kx3 @3 D3(5D\05 x6D67D79D\ 9 h:Dp:;D\; =D\= X>D\`> ?D\? @D\A HBD\PB CD\C DD\D 8FD\@F GD\G HD\H (JD\0J xKD\K LD\L ND\ N hOD\pO PD\P RD\R XS`S    hS " pS (xSSSSS SS S ,S4T  PT0`TT(TTT >T .(UXU"UV.(V.XV>V2V>W6@W.xW.W W"W  X(XD@X2X^X" Y HYXYhY $pY(Y Y(Y.Y.(Z(XZZZ Z(Z.Z([8[@[(P[0x[([[[ B  [  [ \ "\"8\`\\\\ \&\H\ ]00]`] h]>] ]0]^^@(^ h^0x^^^6^ ^0_8_@_6P_ _0___:_ (`08`h`p`<` `0` aa a@@a a0aaa<a b00b`bhb6xb b0bbb4c @c0Pccc8c c0cd d88d pd0ddd@d e0(eXe`e@e e0eff: f `f0pfff:f g0g@gHg6Xg g0ggg<g 0h0@hphxh>h h0hii<0i pi0iii8i j0jHjPj:hj j0jjj8k @k0Pkkk8k k0kl l60l hl0xlll<l m0mHmPm6`m m0mmm:m 8n0Hnxnn6n n0noo:(o ho0xooo:o p0pHpPp8hp p0ppp<q @q0Pqqq<q q0q r(r:@r r0rr rr rr s0s @sHs Ps0ps sss  s ss  s st tB  t  t tt t &t t u " u (u.@u (pu u B uuuuu  NuFuv v (v"5@v rhvv$v .w  w 0w^Pwwww&Mw x 0x@x Hx Px^Xxxxy&My0y @yPyXy `y   hy py yy y yy y B yyyyyyy  NzF z@z Pz `zhz pz"5z  z n`{ { { 2N{ | 0|8| @| z^H| || | &M| } } 0}8} @} H}n^h}} }}&M} ~ 0~@~ H~ X~h~ p~ ~~~ B ~~~~~~~  N~F~ ( 8@ HP X` hp x"5 (n  2N  @P$X "p    . ȁ؁ ^&M؂  z^  &M    n^@ Ȅ&MЄ  4 f^X Ѕ؅&M ( 0 @P X hxB   NFІ  "5( <NP$ .  Ї  |^ p x^ (&M0X hx  ^(0&M8` p      Ȋ ؊ B   "( P`p(0&8` p    Ќ ،B  N"T 8H^X&M H Xh p     B ȎЎ N؎"T 0^@؏&M  0@ H Xh p B  N"TА ^ȑБ&Mؑ  ( 8H P `pxB  N"T ؒ^&Mؓ    ( 8HPB X` Nh"T ^Дp&M ȕؕ    (0B 8@ NH"Th ^Xhp&Mx  ȗ ؗ  B  ( N0"TP x^8HP&MX   ș Й  B  ( 0  N8FXEx   Ț!ؚ "5 4N  X `h p x  + ,  &3؛ ( @ HP (X6Bx  (Ȝ$   ((&Hp x (@B  ( @ HP (X``x؞  (6BH PX (` FOȟ П؟ (\`` hp (x Ƞ (Р<B0 8@ (HV`h ȡС (ءf`` hp (x Ȣ (Т>B0 8@ (Hh ( (06BP      ȤФ ؤf^P `h&Mp   Х   B    (08  @`  f &(P ` p    Ч  B  N"T  HXhBx j^Ш@PX&M` j^(8@&MHp   Ȫ ت  B  NF( H%X.-x l^0@H&MPx   Ȭ Ь  B  NF0 P ` p"T,ȭ0ح(Ю$>j^( &M C^( Ȱ&Mа   j^(&M j^&MȲ ز d^`px&M  ȳг س    ( B 08 N@F` ^HX`&Mh   ȵص   B  N F@ `p^(8@&MHp     з B  NF  @P^` &M(P `p x   ȹ B й5ع5  N ( F08iP    $ ^ `p x &M  Ȼ л     0] ] ] ]  ] (] P] H] x] p] ] ] ] ] ] ] @] ] h] ] ] ] 8] ] `] ] 0] ] DX] D'<'>'@'B'D'v'J'L'N'P'R'T'V'X'Z'\'F'H'^'`'b'd'x'z'j'nA|passError$.B@~'rError$.!B@*$'pB2Investor Details$.%!d$'G2Investor Details$.%!d$'  G2Investor Details$.%(Please enter CINA@passInvestor Details$B@0|d Please Prefill Company NameA@passInvestor Details$B@0|@k8k0A'rError$.!B@*$'p&$'$'v vStop r passInvestor Details$B@0Error! Please refer ErrorA@      !"#$%&'()*+,-./01246789B;<=>?@A3CDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|~|@ re Invalid data present at row no:: p .Kindly refer ErrorSheet Error! Please refer ErrorA@|kpassInvestor Details$B@0oh]8PWorkbooks("InvestorDetailExcel.xls").Sheets("Investor Details").Unprotect "pass"passInvestor Details$.B@~MsgBox rowCount6ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).RowInvestor Details$.B@0A1$.%.O10:O p$ %' Investor Details$.%(%Workbooks("InvestorDetailExcel.xls").passInvestor Details$.B@0Investor Details$.B@0zPHpassInvestor Details$.B@0Investor Details$.B@0iXMACROS BY EXCELZOOM.COM]]*Set rangeSheet = Cells.Range("A15:O65536")passInvestor Details$.B@~X   A15:O65536$%.   !$ B@k..passInvestor Details$B@0o]++++++++ + + + + + +++++++++++]P]h ''MsgBox "RowCount Value ::::" & rowCount   p rStop'z`kX   WIf ((colCounter = 1) Or (colCounter = 4) Or (colCounter = 9) Or (colCounter = 10)) Then           $Investor Details$.%!d'  $Investor Details$%$' Investor Details  $$'k Investor Details  $$'kX Investor Details  $$'k Investor Details  $$'k Investor Details  $$'k Investor Details  $$'k8 Investor Details  $$'k Investor Details  $$'k      Investor Details  $$'   e Investor Details$%$' $INDIAInvestor Details  $$' 'dInvestor Details  $$' 'k@k8d0Investor Details  $$'k   Stop StopStop'ki]D*  %!'   $ : $8Blank Rows Found.Do you want to Clear Rows from row no.  to   ???'    Deletion Confirmation$'  GC@j|X qP |H k@ o(   : $%!''z  'i 8]]]]   $.%!d'   $%$'    $%$Error at line number . column 1 or 3 (Investor First or Last Name)  : Mandatory Field' rzx kp  rError$%( r 'rStop'k e e  $%$Error at line number 6 column 4 or 6 (Father/Husband's First or Last Name)  : Mandatory Field' rzH k@  rError$%( r 'rStop'k e  e  $%$Error at line number 8 column 10 or 11 either District or Pincode is mandatory' rz( k  rError$%( r 'rStop'k  e  e  $%$  $%$Error at line number  Column  D Either Folio Number or DP Id-Client Id-Account Number is mandatory' rzk  rError$%( r 'rStop'khk`  e  $%$  $%$Error at line number  Column  D Either Folio Number or DP Id-Client Id-Account Number is mandatory' rz`kX  rError$%( r 'rStop'kkdError at line number  column  ( ) : Mandatory Field' rzpkh  rError$%( r 'rStop'kd    Investor Details  $'k  Investor Details  $'kh  Investor Details  $ 'k( Investor Details  $ 'k For Country Investor Details  Sheet3A2$'k For FolioNoIf (colCounter = 12) ThenD IsValid = validFolioNO("Investor Details", rowCounter, colCounter)End IfFor DpIdClientIdAccountNo  Investor Details  $'k For State  Investor Details  Sheet3B2$'  $%' Stop Investor Details  Sheet3$'BkkFor Character Length Investor Details  $'kP Investor Details  $'k Investor Details  $'k Investor Details  $'k  Investor Details  Sheet3InvestmentLtgtn$ 'k For Proposed date  $"   $%$'$ $  $$$'& &JAN &FEB &MAR &APR &MAY &JUN &JUL &AUG &SEP &OCT &NOV &DEC $- *'( ( $- *', $ , $ , $'. .Error at line number  column  ( ) : Invalid Date Format' rzk  rError$%( r 'rStop'k $0 2$0 Error at line number  column  ( )3 : should be less than or equal to the system date.' rzk  rError$%( r 'rStop'khd`Error at line number  column  ( ) : Invalid Date Format' rzk  rError$%( r 'rStop'kdxError at line number  column  ( ) : Invalid Date Format' rzk  rError$%( r 'rStop'kdError at line number  column  ( ) : Invalid Date' rzk  rError$%( r 'rStop'kkk Stop >Stop BStop @Stop FStop HStop ^Stop JStop 4Stop NStop RStop 6Stop VStop XStop ZStop \Stop PStopStop'<k <StopStop'kXiP8 :$!'< :$!@'>  $.%!d'   $%'B BA1:A248Sheet3$% %F'D D$HError at line number  column  ( ) : Invalid Country'J rzk J rError$%( r 'rStop'k StopStop'>k >StopStop'kXiP :$!'< :$!@'>  $.%!d'   $%'B   $%'L LB2:B37Sheet3$% %F'N N$H LNA BINDIA BA1:A248Sheet3$% %F'P P$H&$stateName=NA and CountryName=invalidError at line number  column  ( )N : Incorrect Country State Mapping. Please select an option from the drop-down'J rzk J rError$%( r 'rStop'kd Y(stateName = NA and CountryName = INDIA) OR stateName = invalid and CountryName = 'INDIA'Error at line number  column  ( )N : Incorrect Country State Mapping. Please select an option from the drop-down'J rzk J rError$%( r 'rStop'k0d*stateName = valid and CountryName <> India B$INDIAError at line number  column  ( )N : Incorrect Country State Mapping. Please select an option from the drop-down'J rz k J rError$%( r 'rStop'kk StopStop'@k @StopStop'kp Next CounteriP]8]P]h]] ^ ! \%%!'R ^ ! \%%!'` ^ ! \%%!'T ^ ! \%%!'V ^ ! \%%!'b ^ ! \%%!'X ^ ! \%%!'d ^ ! \%%!'f ^ ! \%%!'h ^ ! \%%!'j ^ ! \%%!'l ^ ! \%%!'n ^ ! \%%!'p ^ ! \%%!'r ^ ! \%%!'t ^ ! \%%!'v ^ ! \%%!'x ^ ! \%%!'z ^ ! \%%!'| ^ ! \%%!'~ ^ ! \%%!' ^ ! \%%!' ^ ! \%%!' ^ ! \%%!'9MsgBox "rowColumn11: rowColumn11 value is " & rowColumn11 R ` R T R V R b R X R d R f R h R j R l R n R p R r R t R v R x R z R | R ~ R  R  R  R  R' ` R ` T ` V ` b ` X ` d ` f ` h ` j ` l ` n ` p ` r ` t ` v ` x ` z ` | ` ~ `  `  `  ` e `' T R T ` T V T b T X T d T f T h T j T l T n T p T r T t T v T x T z T | T ~ T  T  T  T e T' V R V ` V T V b V X V d V f V h V j V l V n V p V r V t V v V x V z V | V ~ V  V  V  V e V' b R b ` b T b V b X b d b f b h b j b l b n b p b r b t b v b x b z b | b ~ b  b  b  b e b' X R X ` X T X V X b X d X f X h X j X l X n X p X r X t X v X x X z X | X ~ X  X  X  X e X' d R d ` d T d V d b d X d f d h d j d l d n d p d r d t d v d x d z d | d ~ d  d  d  d e d' f R f ` f T f V f b f X f d f h f j f l f n f p f r f t f v f x f z f | f ~ f  f  f  f e f' h R h ` h T h V h b h X h d h f h j h l h n h p h r h t h v h x h z h | h ~ h  h  h  h e h' j R j ` j T j V j b j X j d j f j h j l j n j p j r j t j v j x j z j | j ~ j  j  j  j e j' l R l ` l T l V l b l X l d l f l h l j l n l p l r l t l v l x l z l | l ~ l  l  l  l e l' n R n ` n T n V n b n X n d n f n h n j n l n p n r n t n v n x n z n | n ~ n  n  n  n e n' p R p ` p T p V p b p X p d p f p h p j p l p n p r p t p v p x p z p | p ~ p  p  p  p e p' r R r ` r T r V r b r X r d r f r h r j r l r n r p r t r v r x r z r | r ~ r  r  r  r e r' t R t ` t T t V t b t X t d t f t h t j t l t n t p t r t v t x t z t | t ~ t  t  t  t e t' v R v ` v T v V v b v X v d v f v h v j v l v n v p v r v t v x v z v | v ~ v  v  v  v e v' x R x ` x T x V x b x X x d x f x h x j x l x n x p x r x t x v x z x | x ~ x  x  x  x e x' z R z ` z T z V z b z X z d z f z h z j z l z n z p z r z t z v z x z | z ~ z  z  z  z e z' | R | ` | T | V | b | X | d | f | h | j | l | n | p | r | t | v | x | z | ~ |  |  |  | e |' ~ R ~ ` ~ T ~ V ~ b ~ X ~ d ~ f ~ h ~ j ~ l ~ n ~ p ~ r ~ t ~ v ~ x ~ z ~ | ~  ~  ~  ~ e ~'  R  `  T  V  b  X  d  f  h  j  l  n  p  r  t  v  x  z  |  ~      e '  R  `  T  V  b  X  d  f  h  j  l  n  p  r  t  v  x  z  |  ~      e '  R  `  T  V  b  X  d  f  h  j  l  n  p  r  t  v  x  z  |  ~      e '  R  `  T  V  b  X  d  f  h  j  l  n  p  r  t  v  x  z  |  ~      e 'k,i,passInvestor Details$.B@~]] ]0 ]H ]` ]x B2$!d'AP1Sheet3$.%!d$'B2Investor Details$.%!d$'  G2Investor Details$.%(Please enter CINA@passInvestor Details$.B@0| +k+6https://www.mca.gov.in/FOServicesWeb/NCAPrefillService'&' t'  '  '  '  '  CIN '   '  ZIE4 '  䴡'  '  '  ' ' post C@Host1http://mca.gov.in/FOServicesWeb/NCAPrefillServiceC@ Content-Typetext/xml; charset=utf-8C@ soapActionFhttp://mca.gov.in/FOServicesWeb/NCAPrefillService/getNCAPrefillDetailsC@Accept-encodingzipC@ C@5 B@q& //companyOrg1 %!d'//crDat %!d $' passInvestor Details$.B@~G2Investor Details$.%(B2Investor Details$.%(passInvestor Details$.B@0Invalid CIN/BCINA@kX% passInvestor Details$.B@~ G2Investor Details$.%(passInvestor Details$.B@0k$ passInvestor Details$.B@~ Z10Investor Details$.%(passInvestor Details$.B@0k($o $  $.%!d'#   $%'B   $%'L   $%' B$'B BINDIAKT LAndaman and Nicobar IslandsKT AndamanandNicobarIslandsSheet3$% %F' $HInvestor Details  Sheet3$'k"Andhra PradeshKT  AndhraPradeshSheet3$% %F' $HInvestor Details  Sheet3$'k!Arunachal PradeshKT ArunachalPradeshSheet3$% %F' $HInvestor Details  Sheet3$'kP!AssamKT AssamSheet3$% %F' $HInvestor Details  Sheet3$'k BiharKT BiharSheet3$% %F' $HInvestor Details  Sheet3$'k0 ChandigarhKT  ChandigarhSheet3$% %F' $HInvestor Details  Sheet3$'k ChhattisgarhKT  ChhattisgarhSheet3$% %F' $HInvestor Details  Sheet3$'Stop'kDadar Nagar HaveliKT DadarNagarHaveliSheet3$% %F' $HInvestor Details  Sheet3$'k8 Daman and DiuKT  DamanandDiuSheet3$% %F' $HInvestor Details  Sheet3$'kDelhiKT DelhiSheet3$% %F' $HInvestor Details  Sheet3$'kGoaKT GoaSheet3$% %F' $HInvestor Details  Sheet3$'kxGujaratKT GujaratSheet3$% %F' $HInvestor Details  Sheet3$'kHaryanaKT HaryanaSheet3$% %F' $HInvestor Details  Sheet3$'kHHimachal PradeshKT HimachalPradeshSheet3$% %F' $HInvestor Details  Sheet3$'kJammu and KashmirKT JammuandKashmirSheet3$% %F' $HInvestor Details  Sheet3$'k JharkhandKT  JharkhandSheet3$% %F' $HInvestor Details  Sheet3$'kX KarnatakaKT  KarnatakaSheet3$% %F' $HInvestor Details  Sheet3$'kKeralaKT KeralaSheet3$% %F' $HInvestor Details  Sheet3$'k( LakshadweepKT  LakshadweepSheet3$% %F' $HInvestor Details  Sheet3$'kMadhya PradeshKT  MadhyaPradeshSheet3$% %F' $HInvestor Details  Sheet3$'k MaharashtraKT  MaharashtraSheet3$% %F' $HInvestor Details  Sheet3$'kHManipurKT ManipurSheet3$% %F' $HInvestor Details  Sheet3$'k MeghalayaKT  MeghalayaSheet3$% %F' $HInvestor Details  Sheet3$'kMizoramKT MizoramSheet3$% %F' $HInvestor Details  Sheet3$'kxNagalandKT NagalandSheet3$% %F' $HInvestor Details  Sheet3$'kOrissaKT OrissaSheet3$% %F' $HInvestor Details  Sheet3$'kP PondicherryKT  PondicherrySheet3$% %F' $HInvestor Details  Sheet3$'kPunjabKT PunjabSheet3$% %F' $HInvestor Details  Sheet3$'k  RajasthanKT  RajasthanSheet3$% %F' $HInvestor Details  Sheet3$'kSikkimKT SikkimSheet3$% %F' $HInvestor Details  Sheet3$'k Tamil NaduKT  TamilNaduSheet3$% %F' $HInvestor Details  Sheet3$'kP TelanganaKT  TelanganaSheet3$% %F' $HInvestor Details  Sheet3$'kTripuraKT TripuraSheet3$% %F' $HInvestor Details  Sheet3$'k Uttar PradeshKT  UttarPradeshSheet3$% %F' $HInvestor Details  Sheet3$'kx UttarakhandKT  UttarakhandSheet3$% %F' $HInvestor Details  Sheet3$'k West BengalKT  WestBengalSheet3$% %F' $HInvestor Details  Sheet3$'k8 n0 n( BINDIA LNA NAInvestor Details  Sheet3$'k d LNA NAInvestor Details  Sheet3$'kX kP kH StopStop'Bk BStopStop'k i P Error at line number  column   (   $.%!d,) : Incorrect Country State District Mapping'J rz8 k0 J rError$%( r 'ri  passInvestor Details$.B@~E4Investor Details$.%(passInvestor Details$.B@0o` P ] ] 'Z]  $.%!d'   $%'  ' p     $ +. $@$ $[$  $`$ ${$ d $ $   $'  counter = counter + 1Error at line number  column  ( )1 : More than one consecutive space is not allowed'J rzk J rError$%( r 'rStop'ykdError at line number  column  ( )9 : Special Characters and Numeric Values are not allowed.'J rzk J rError$%( r 'rStop'ykk StopStop'Fkh FStopStop'k@i8x ] ]0 ]H '']`  $.%!d'   $%'  '  ] '     $ +  / F $@$ $[$  $`$ ${$  $/$ $:$  $@$ $[$  $`$ ${$   'k $/$ $:$   'kd'Error at line number  column  ( )& : Special Characters are not allowed.'J rz k J rError$%( r 'rStop'yk  Error at line number  column  ( ) : Should be alphanumeric.'J rzk J rError$%( r 'rStop'k StopStop'Nk NStopStop'khi` ]p]']']  $.%!d'   $%'  ' ]'](']@']X'     $ +/;R $@$ $[$  $`$ ${$  $-$ $/$ $:$  $@$ $[$  $`$ ${$   'k~ $/$ $:$   'k~ $-$   'kh~  '   $' -'counter = counter + 1Error at line number  column  ( )7 : More than one consecutive '-'(hyphen) is not allowed'J rzX}kP} J rError$%( r 'rStop'y}k|k|d|'Error at line number  column  ( )& : Special Characters are not allowed.'J rzH|k@| J rError$%( r 'rStop'y{k{{  Error at line number  column  ( ) : Should be alphanumeric.'J rz8{k0{ J rError$%( r 'rStop'kz    Error at line number  column  ( ) : Invalid Format.'J rz(zk z J rError$%( r 'rStop'ky StopStop'Hky HStopStop' kyixyp]]('Z]@  $.%!d'   $%'  '      $ + $/$ $:$ dhx $.$   $' Z 'Z .Error at line number  column  ( )( : More one decimal point is not allowed'Jkw Z Error at line number  column  ( )- : More than one decimal point is not allowed'J rzvkv J rError$%( r 'rStop'yvkxvdpvError at line number  column  ( )4 : Special Characters and Alphabets are not allowed.'J rzuku J rError$%( r 'rStop'yxukpukhu`u StopStop'^k8u ^StopStop' kuiu]8  $.%!d'   $%$' '  Error at line number  column  ( )N : Folio Number Should be alphanumeric and less than or equal to 20 Characters'J rzsks J rError$%( r 'rStop'kxs StopStop'NkPs NStopStop'k(si sP]  $.%!d'   $%$' ' < Error at line number  column  ( )O : DP Id-Client Id-Account Number Should be Less Than or equal to 60 Characters'J rzqkq J rError$%( r 'rStop'kq StopStop'Pkhq PStopStop'k@qi8q]  $.%!d'   $%$' ' # Error at line number  column  ( )D : Investor First Name Should be Less Than or equal to 35 Characters'J rzpkp J rError$%( r 'rStop'ko StopStop'Rko RStopStop'khoi`o]`  $.%!d'   $%$' ' # Error at line number  column  ( )E : Investor Middle Name Should be Less Than or equal to 35 Characters'J rz0nk(n J rError$%( r 'rStop'km StopStop'6km 6StopStop'kmimx]  $.%!d'   $%$' ' # Error at line number  column  ( )C : Investor Last Name Should be Less Than or equal to 35 Characters'J rzXlkPl J rError$%( r 'rStop'kl StopStop'Vkk VStopStop'kkik0]  $.%!d'   $%$' ' # Error at line number  column  ( )L : Father/Husband's First Name Should be Less Than or equal to 35 Characters'J rzxjkpj J rError$%( r 'rStop'k j StopStop'Xki XStopStop'kiii]  $.%!d'   $%$' ' # Error at line number  column  ( )M : Father/Husband's Middle Name Should be Less Than or equal to 35 Characters'J rzhkh J rError$%( r 'rStop'k8h StopStop'Zkh ZStopStop'kgig]@  $.%!d'   $%$' ' # Error at line number  column  ( )K : Father/Husband's Last Name Should be Less Than or equal to 35 Characters'J rzfkf J rError$%( r 'rStop'kXf StopStop'\k0f \StopStop'kfifX]]'Z](]`'  $.%!d'   $%'  $%' ' 'd8e      $ + $/$ $:$ dd'ydkddkxd     '$'   $DELHI    e $HARYANAdc'kc   e $ CHANDIGARH $PUNJABdHc'k8c   e $HIMACHAL PRADESHdb'kb   e $JAMMU AND KASHMIRdb'kxb   e $ UTTAR PRADESH $ UTTARAKHANDdb'kb  # e $ RAJASTHANda'ka $ ( e $DADAR NAGAR HAVELI $GUJARAT $ DAMAN AND DIUd a'ka ( - e $GOA $ MAHARASHTRAd`'k` - 2 e $MADHYA PRADESH $$ CHHATTISGARHd0`'k ` 2 6 e $ANDHRA PRADESH $ TELANGANA $ PONDICHERRYd_'k_ 8 < e $ KARNATAKAd@_'k0_ < A e $ TAMIL NADU $ PONDICHERRYd^'k^ C F e $KERALA $ LAKSHADWEEP $ PONDICHERRYd8^'k(^ F K e $ WEST BENGAL $ANDAMAN AND NICOBAR ISLANDS $SIKKIMd]'k] K N e $ORISSAd@]'k0] N O e $ASSAM $ARUNACHAL PRADESHd\'k\ O P e $NAGALAND $MIZORAM $ MEGHALAYA $MANIPUR $TRIPURA $ARUNACHAL PRADESHd['k[ P V e $BIHAR $ JHARKHANDdp['k`[dX['kH[d@['k0[k([ Error at line number  column  ( ) : Invalid Pincode'J rzZkZ J rError$%( r 'rStop'k@Z StopStop'JkZ JStopStop'kYiY]8]P'Z]h  $.%!d'   $%' '  Error at line number  column  ( ) : Invalid Pincode'J rzXkX J rError$%( r 'rStop' insert here else partkhX StopStop'4k@X 4StopStop'kXiX]@  $.%!d'   $%$' '    4[A-Za-z][A-Za-z][A-Za-z][A-Za-z][A-Za-z]####[A-Za-z]' Error at line number  column  ( ) : Invalid PAN Format' rzVkV  rError$%( r 'rStop'kPVdHVError at line number  column  ( ) : Invalid PAN Length' rzUkU  rError$%( r 'rStop'khUk`U StopStop'`k8U `StopStop'kUiUX]  $.%!d'   $%' '   Investor Details  $ StopStop'd@TError at line number  column  ( ) : Invalid Aadhar Number'J rzSkS J rError$%( r 'rStop'k`SkXS StopStop'dk0S dStopStop'kSiS]  $.%!d'   $%' '  $"   $%$'$  YYYY/MM/DD$' $  $$$'& &JAN &FEB &MAR &APR &MAY &JUN &JUL &AUG &SEP &OCT &NOV &DEC $- *'( ( $- *', $ , $ , $'. .Error at line number  column  ( ) : Invalid Date Format' rzPPkHP  rError$%( r 'rStop'kO $0 2$0 Error at line number  column  ( )3 : should be less than or equal to the system date.' rz8Ok0O  rError$%( r 'rStop'kNdNError at line number  column  ( ) : Invalid Date Format' rzPNkHN  rError$%( r 'rStop'kMdMError at line number  column  ( ) : Invalid Date Format' rzhMk`M  rError$%( r 'rStop'kMdMError at line number  column  ( ) : Invalid Date' rzLkL  rError$%( r 'rStop'k0Lk(L StopStop'bkL bStopStop'kKiK]h  $.%!d'   $%' ' d Error at line number  column  ( )M : Father/Husband's Middle Name Should be Less Than or equal to 35 Characters'J rzJkJ J rError$%( r 'rStop'kHJ StopStop'zk J zStopStop'kIiI]   $.%!d'   $%' ' d Error at line number  column  ( )M : Father/Husband's Middle Name Should be Less Than or equal to 35 Characters'J rzHkH J rError$%( r 'rStop'khH StopStop'xk@H xStopStop'kHiH8]  $.%!d'   $%' ' d Error at line number  column  ( )M : Father/Husband's Middle Name Should be Less Than or equal to 35 Characters'J rzFkF J rError$%( r 'rStop'kF StopStop'jk`F jStopStop'k8Fi0F :$!'< :$!@'>  $.%!d'E   $%' AS2:AS3Sheet3$% %F' $H`EError at line number  column  ( )l : Invalid Investment under any Litigation /Is the shares transfer from unpaid suspense account Column value'J rzDkD J rError$%( r 'rStop'k0D StopStop'lkD lStopStop' kCiCCAttribute VB_Name = "Module1" Public isValida teManor@y As Sng JCount@St~DisWct!InvType AlphapNume1@IndianP incod1Fo0rgieFolioEber4DpIdCl'@tIdAccNo}estorFirstؖtMiddlerLa]FatherHusb@`! " #AyriccqWPanX^@O@fBirth A adharqNomineXLengJointH`olderd Remarks(@yPLtgt9S0esFromUnpaidSuspe8nseDI FyrowxDoeFerrorZisPrefillZcked aBooleanA0Sub 3/()!$ J& $Allab +~|){ yJ,xv&cgsw(rn  Ftr DHq o*h9 q iJ d!U0 CaGove_Spaces Sheets("Ec").!mrote("`pass"`]jg= 1 Cells.Cer p= getRdr#f`CINTrim(K Detail.Range("B2`0TextaompanyRa= ? f?G8aIf f"" The>_u `8`MsgBox "Pse entF@WopPS4.PPw ord:=S, UserIfOnly:=TruM Exit AI Els# T  ` $O CS qc  or  End  D+FindABlank$)))t`')um1cul<*t\?CW:@,((*"Stop") A (: < 65537))&P8!!!R# >= #0,1 a pres!. at @? no::" &o!" .Kly H", vbdOK-, G or( !p(b5 Function ! Dim7ma/ RJ)'bookTe>LExcel.xBMU*4wWC4 On " GoToHler X(\'t!Y@ 'A)ve2 .\Sp ecial(xr1t1).7_ V[%ASeK4= 2p^A1f sumdiv8Appa .Sum(TaO10:O&)ao f  4, 5).[30rOPr % _^:x=Fa2]/U(`Qrr:)߿072 P'MACROS BY EXCELZOOM.COM113r"t3~x"8= 2x("A15:O65536") Sheets("Investor Details").Unprotect "pass" On ErrHGoTo RS|et rangeText0 = R .SpecialCells( _ x TypeConstants,EValuesFhEach` Inn If Trim( .=)"" @Then Clear9te9 End If N] RS:gNothin&g C= WorksPP@word:=, UserInterfaceOnly:=TrueKSub Function kidateAll( Dim ColNumber(23) As Doubl  01 1A2I2A3IQ@= 4I45UI5A6I6A7UI7A8I8A9I9A101C---1 .1B.1.1.1 /1B/1/1/1 01B010101 11B11111212121n2_ `121At= 21{col8Cou {ArowP@ ataRowAX'MsgBpox "@Jue :" & N`oh = D ~o(ere>= !@&co èXAtStop Exit _ %wA"= LB#d(]) U!*'( 3Or k Gn =n@V`  r ^/ R@,RS. SE,fie A& @10 O17O 18O O9Lalpha eric c(Else'_ :[crynmB¹O^W O^8Jb'UCaseP9"INDIA"j1indianPincodeèflagp $6; [foriegoAAo! IUSUp2pMfaPyQ W0c8tcSa"r &R| #1 Pic F!FirstBlank PLastpWithLo.= ,.q("*S`chDir@@:=xlPrevious).rBaCurr@ 15a  Is 0 !  `s(BCow & ":"PLastRowWithValu e) msg = "Blank s Found.Do you want to Clear>from rno. Cur>rrT ???"respMsgBox(, vbQuestion + OKCancel, "DeleConfirmaE "If +vbOK Then .atentsCExit Sub End g IfNext  - Publi@c FuncdIs() As Boon%On Error GoTo  xs.SpecialCells(xType@Astvs, 23).C=|tB$Fa8lseBH. D : Tru@ = G  validateManory(She@etData>String,%$erADoNe,0 colN Dim errCCflagieldTi[C 'ʉ aRe sume x H f= 1sG3V]9-).= Trim(WorksABۄ=B>B!"^"^e}@(('=x 1)d?ow&3)))@D a1Xat line num>b:!bumn 1 ]3 (Inv`Fir st! Name) " : I F1o``ord >= 65537 !a]B~H8"B"e@,/.5`Vh aY=8+ 1\@-StopL AqE{>C3C4J9[ 6Ja|Jnt-@L&DdJ4G6 (Father/Husb'KKK<K K!K@(;%%@#%%6'M"O%(10_% !+JDd%79S11o%u r0o%Jrk%10q%11 e@(DislcJPincode is mnI JIB I$-$Ier$g7 I$ $$$ߠL[2?$/$tow(*$2/$6 /)esspo)o)h)Coltu4qP E*Fol0io N3xuDP Id-ClipAcc+l +u,+ ++++(+vP+3 P .-_*,ow_%_%pZ*_%5ݰ(SS&1_/_*fr_*z_*@U_*-_*/V _*_*_* o_*_*_*_*_*_*CTR*= "Stop" End = 65537 Then WExit Functio  Workshe ets("s").Cells( <, 1).Value > #a+ 1 fla + n@E(X= 1 OTr J3N4N6)Qis8id@,alphaNumeric("Invesh Det@ails",H~,)( Z+2LvalieFoliop  ͪ J3=1q DD@A5W"/nq/` b'F}iry83$$olBer, l3G"A2"3sE "@No$'o(LI' >X#O?&%@I@"DpIdClientIdAccO pVStat9?d/t@B@ disttNamSFData%=05~<> A* A"\DD3@&E~10g,.3',$CharacvLengthϓ&- = % \Firs o^< i .{9LafvDn;G4_nUFatherHusbpI( @$  w //yƘoai2/2~q%YesorNzz@c mTLtgtna91q43Proposed qdM1 IsPGe&("uem$cc%Trim(JJ1p"+P8(cc2)11} ffMid(UCase, 4, ~3ha{`R"0JAN"FE"BMARAPMAYJUYHJULyUGSDEPOCTNOVDEC"Ͻ gQInStr(1.c0$- Jvb1Compareqhhpcз izi4c-8 hh!ii) @f/4a0ݣ ///r/W&5Q , matl% "֕z/n< 3s/;po/g-% = OOr @(DD>"sNow)b?n errMsg = "Error at line number " & rowCount& colum.n22(XfieldTextp")"" : should be less than lequal toe system date."If ort>= 65537 TheExit F@unctioE nd If:Worksheets(").Cells( F, 1).Value ' h+ 1flaStop_&KEls~eC/&;҄Invalid D| FormatP6|{Jy׮xwב+lprAu zz_8A"_8'_8u_8?u_8e_8 n% ';! ??A8I>u<<^;;`;9 : ' ! OrH is@idryA"HDistrictqSta`AlphaN`umeicL(1L@mIndianPincodal"xZiegG Folioq; 2#estorFirstNam JMiddleg_La%FatherHusband?"CDpIdClientIdAccNoG!pMp aW!$$$RurO)-g 3%d*(Sяpza As S)ng,iPDouble,adRXL-7 ;)QQ!RowRange(Ie).P Col.P!G= s' 9 ).!qW On" Res`5 NYry)hI edzen!Chk Applica1.Match(X, OR3`"A1:A248"), 00KC#IsR @5)oGoTo 0@`Io?lu!@f°=bry;fp [:/f04I` df/Uerw Kf@4CP&#]C`{B/F.F"mFFFDU1AFst7FFFta1=F;?FtAFF OETOEq - 8 sA:,SheetData).Cells(rowCounter, colX) stateNameChk = Application.Match(@, Workss("3").Range("B2:B37"), 0If Is`ErrorAb) Thenx $^|"NA" Andry <> "INDI:8 cry%`A1:A248?a05i:i 'd=NA abb=invaliFd&/On @GoTo 0 sDtr= "at line number " ,& "um.n GyA( fieldTextA)A" : Incorrect + SA Mapping. Please selA an opA from the drop-down" 0Ke,>= 65537DWExit` FuncAKETIfɣH , 1).VaxlueDU)=" + 1 flag"StopH<' ElN'@OB) OR^ DM ' '&_F_F_F_F _F _FF!M_F_F %[_FNFY CE?B?IndiRaUC@t(()=Ӧ Ky& "flIbCK/BBb)??$az`lisid#f' TPKb&P 'Nc/ wZ getR() As DoubDle*Dimjl j1314600* R-`fve2$9p s. b(xlUpow 2WAowH2).Co3w3445566m77889f910101 f""1o&a:*&.&&&&&&&&''/'?'O'_'2_'2_'_'_'_'_'_'_'_'_'iMsgBox ""11:f1 mis'T1p@rv(B!' 0l@y\4m567Jmn8) And (rowColumn1 >= h9x10>1>2345Z6712U22224)) Then getR!unt 1 ElseIf (lj2ʉ)!NqqppNppF1Wp\N1N1N1'1'1'``'`'`a2`3`<88n8N8.8``8<#18\'`'`'``'`G'0`mn30mn40n^ 0>000{00 ///n40mn5~n ^ N>.0{0 0 0?00n50mn6~n ^ N>.0{Oolumn16) And (rowC6 >= h17|8>9>T201234)) Then getBRunt 6 ElseIf (7 3 S R 4.5 .Npp1pWp\F1F1F1G'O1O2O2O2O2`7`8`<n<`.<8`8<#`|#`#/`'``'```8`9``<`N<000{00`0/ln90У0 1 1  / ? O _ o   /1Oa ?, o1o1n101p11191  ?/d 1/ ? O _ o   1$FGwColumn11 >= ro23) And ( 4)) T@hen getRvunt 11 ElseIf (2 v1j 2 ?4U?5678e9101U1H1I1]I1UI1I1J2J2_ݚ 23*}|O>/>>==b = ](b,$b,$b,%b+b %b,b3b4bobbO>b>b=b b / ? O _ o   11    1n141051*  1/11  / ? O _ o   1b , 11n151p161z1  /111 1 / ? O _ o   11 , w1?66?1017?121<wColumn17 >= ro2) And ( |3|4>5>6789101111111J2J2J2J2J24)) Then getBRunt 17 ElseIf (ȴ8ʼ*))sOsszO=pb =(1](pbL (pb,(1(pbK pb ^M%pbL b8rb9|bob9ob9o9obobpb O= ](pb,(pb,o   ?11   & ?1}b9?1mn20?1~ n >1>1?1  /,? O _ o     g,?1<120?1011?1:1o ?12 ?1 / ? O _ o    d?1 ,?1=11?1012?1:1o ش (rowColumn22 >= p7) And8|9>10@1 2 3 4 Z5611U222J24)) Then@ getRunt 22 ElseIf (Ȕ3ʔ!t)sOssrrOr ]P1P1P1(1(1(1(pb =)pb+pb =)b23rb4|b9999o9ob/9pb ob ](pb,(pb,(pb,)+pb  m 3b|b401pIpf 1E@FunctioPf`Sub Prefill_WS1() Sheets("Investor Details").Unprotect "pass" Dim xmlhtp As New M@SXML2.@H TTP30zDo"cuDOMumentIsURL!String0sEnv}trCINm sompanyNatme 1= Range("B2TextS@Verspy`Trim(r3 AP10j?.2`F ""1uG Value " MsgBox "Please er 7(6!P!A Exit &'(("= "https://www.mca.gov.in/FOServicesWeb/NCAT*TO Ta!$= b& ""! 1%q<>/U uT<.oCont0I-TypRe"t@Y/5; char=s= Ao!t< {  /O3qAccept-encoding", "zip"  .send sEnvLxmlDoc.LoadXML .responseTex tJEfWith strCompanyName = SelectS}leNode("//c(Org1").WCIncorportaionDatILeft(Nr(H, 10)! If ("") ThenSheets("InvestorH DeAls+U nprotb "0passRa$nguG2 VaTluc"*B0PTMsgBox A7alid CI8N/B$sIf CPL<> LLKnk@8 79*Z10@8"9;SubAt FunctiL va?@jDiict(`ga A s Strt, rowCounterDouble, colL ofie\lda{`s ).Cells(9 'On ErBr@qResu@N+crōWorksx  G - 2Dst" a# 1 dD+ (kUCase(hc 4`6!#a]"NDIA"aGDAnda man a@Nicobar Is>l@l!Ap plica!Q.M atch( , .""83dĨ dF, Ž|s' xd1'Bihar3t :wOCh]igarNDoooo`&@NsXhattis7E:: flag`"StoYodDadNa` Haveli>B2%C>> isValid = error("Investor Details", rowCounter, 10, "Sheet3") End If6Case ("Daman a$DiuCdistrictNameApplication.Match( , WoHrkss(.Rangeon6, 0ZIf I sE-) Thentelh~iLLL  \GoaKۙBKKGujarat?&?se<&% & rG'L 1|LHaryanLm&& &&&&&"dHimachal PradeshNN'D&(((( JammuBKashmir(ouou0eu2`uE ur}u[XO<(Jharkh@ s9Hooo) `ODsXKarnatakP4ocѦsXeralooooet"K???y????8? 4Laоadweep::'sXMadhya/w?w bbN /////&[vtr;T(;;ڲn isValid = error("Investor Details", rowCounter, 10, "Sheet3")End If6Case ("Manipur=distric tNameApplication.Match( , Works s(.RanDgei, 0UI`f IsE|+)p TheمeghalayaᛟN̝  ݛizoramMܛEMM|NagMnd&te&G & t'ML1M`Orisstm& &&J&&&"dPondichyMM' '?''' Punjab'ttP~t? tb|t????X_:'RajasthanosIF___)e 0BsXSikkitoϛ֝_a1e??C?s????X?4Tamil Nadu&etO"&sXelanu4TO'O'y8rQq___y____8_TUttar Pradesh:?;;zK = error("Investor Details", rowCounter, 10, "Sheet3")  End If6Case ("UttarakhanddistrictNameApplication.Match( , WoHrkss(. Range m, 0If IsE-) Thens|isVali dW BengalA?O̊3?O  SelectqC$(cryB<> "INDIA"̀A state N A&  ? CA8Else9K1= "A@wk`߇sȈflago"Stop"u$*Dĉ  v A ! Func %Į"Data As SngDouble, ColumnL@e>bV=B at line number " &h" c !&@(s().Cells(9).Text ) : InPcorrq ry`( (Mapping"@="$ >= 65537L2eExit G.JK#N" @).^u?!$*++ 21 -C!Sub Clear(8,).Unprot)"pass&E4`"aP o).P,3 P ,alphaNume{'!)--@&/s.pDim i a'Y* %= 03arrAl#field. bL*C* (!iMh Ly,thF() - Re! +rF`i0 To UBhd(Ku 6i)PMid, i %) 3((> Chr(64,) a^<910)) _1Orb (96123)+g ١32u8nBU247"`I?'#8q_R_R]R (S" (pS)"`P@More tP oXconsecutive space is not allowed!: 8`FQ Q9 qyQQϲQQorQ}) 3^or @71xA Special07pcPs S G ! . @Ӄ Q :/qoq   1/|  BE  j>NF1lzlisAmicI9=sO0  gFol|iow?5*#uϴble) Dim iacounter A`s Doulnlf= 0ZR"arrAlNu m(+fieldName = Sheets(Data).Cells(9, colC).Text J"Lenglth?(G))0 - 1Re c fspecialCharF(lagIger"For iE0 To UByd(5ۉi)Mid\, + 1, 1.If (((> Chr(64) And = 65537%Exit FunctioLL15"ar.g$%J= 5f= "Stopo3NF7fT0(F0)?$<<`:hpif P;.\x; An|ZCo0+ 2d04@ 7"-" O@ Q'%=0 q߂????6M ore t` o '-'(0) is nWl /5= Oer1O /orMٴ flag = "Stop"   Exit For dEnd IfL Else2specialCharF18@trName~Error at line number " & rowCount&colum.n (,fiXeldR+)"P : S aBcIs ardot allowed.|If eF->= 65537 Then]unctio Workshe ets("s").Cells( 4, 1).Valus7 I=P<+ PNextC?(acA\= 0 A{n})LB*qlYqhould bemphaericnnnPniGg(hypB <> 2 Or firstLastHypa1)mconsecutives0:?s?s.sInvalidmat9p$sVip9rpe98=ljisAl\Numeic1Ak賲B4 a @g F% a(S!Data As Strin g,Doub0le, () Dim iŊ (carrAl(@ G= Bs'Ū9I).T"嫈A' LenXgth1( ) - Re!O i0@ To UBd(Di)Mid ,  S@G@( > pr(47~ <"58))) _@bث i=6]Aa5n@;o b 2d 4jQcg"."L+  qgoJp"gMoopdmal point is no6ϓ ; (>_t0v OOy ʊ  *O]%< ) * ]'z* [9U_____Zo a0thbO_ϳe t ermɅoV~JAr] WϠz= 65537 T8hen Exit FunctioDEnd If\Worksheets("E").Cells( , 1).Value = strName? "= + 1$flag8"Stop? isqidFolioNumbw= ! b#*valͅ)OI' , DpIdClientIdAccNo(SData As String, rowӀ Double, col )_Dim ifield[P.sg9 )`.TextkTrim(y*)$Length{@!(B%Do(D> 60)Y@ at line nCr" &IH& "Fumn&II@( D@)A" : DPp Id-CdAd ċShould be Less'an or eq@ual to, Charac6 ف ڂan`loIg F qak__6_6 >+lߧq4ߧB\l_6?6?6?63 $Z,ߦ5?6?6___rl/Z4RC1?6S25+6P6Nolg55FatherHusbandߢ?6?6?6lߢCells(9, colCounter).Text fieldValue = Trim(Worksheets(SData).1row~ ) Length (2If (> 35) Then strNamu"Error at line number " & n "umn(,tR& ")" : Father/Husband's First Should be LessKan Dequal toV Characs" feW >= 6p5537jExit Functio|End If(" 4, 1).ӄ G= + 1!flagg"Stop@2@@4JH2is@idPPOO=  3validateWE Middle/ As String,I@Double C@Dim iѯDEB(5oo&ooc0ppp ppp p p(pXz?pp]pGp{pLast?pgm?p?p??c; ) #???e?#p7ppkppq87'*pperpmef`por7pp _lnd,7P"7oO%wo 7indianPincodennn7-nc4NFr1e= 0aarrAlNum(="zFcTru= u歱 &߭ѱ=#stz94skB 3#%<> 6%{1FalsEARezcFi0 To UBd(Ux) -1i)@@a , in_: Eq F(>r(47) A 9<58)) "qyGor{ Q3QN30 w;Qq!> 110Bx< 89Sq h=fDt( / )x, 2( =BUCase(,,"DELHI" P$ 2_ 14 (0HARYANA _ӽC(0q=2/ 14/ 1 *sq9!/ % CHANDIGARH" O r PUNJAB5O/O/H,bN ElseIf (fieldValue >= 17 And < 18) Then ~UCase(statej) = "HIMACHAL PRADESPL HD@ If strNameError at line number " & ro@wCount&column { ())" : InD Pincode6"Qe<#>=@ 65537Exit Func8tiorIDAG%$= + 1 f"StopD5# 8 6isIndianGb7 M,V  foriegE&(SUData As Strin g,@Doub0le, F) Dim iMcD = 0arrAl0Num(G= -sg<9).Text =?(D&]!Length3( @<( > 12mmpmlmXlLami[llulk' insert here e par`<@dUnisFZmld GGa l P@eicF`Pan_ms \mmUd_fRfTrim(f#>g)cbf@ f<> 0e7%8= 1)SrIsPAN8 Like "[A-Za-z]{#5XiKf (rI=-MsahOu>Ouv>Lx"Ou  -mat 7@@3OCW JC8 zE. ) _0__r0S5 |ergc z is@idZ&W  "^ 1bbAadhar ococќSZocf?c `b A?cזperic("estDetails"vx #@OOuO>OD ?Z0\6/o=M:::379|orݖX-$%4  :i3S5dAadharNumber = "Stop" End If H If i sVali THhenZ vJa teFunctio; Pu`blic HDLOfBirth@(Sheeta As String, rowC0ountDoGe, col) Dim i fieldNXame{*s-).Cells(9 ").TextuWorksIJ # Length;(C/'M(<> 0) Is  cc0Trim(0R"G C*2Format!, "Y/MM/DD"!6(cc)11K6KffMid@(UCase , 4, 3B "JAN" ODr CFEBHM$ARHAPIMAYJUIJUL UGHSEPHOCTHNOVH0DEC"j>ggI=In(1@c@T-", vbCompare@hA@+ ii.c Ta6- hh;ihi) W4;EerrMs"Error at l ine n" "&i{& "zumn&{ (bT%")!" : InB g Wb`@or>= 65537<8 ExitƘo "T w$", 1).+[>?fla6ƓF72>5Now)I @IFIIshould be less@ than `Wequal toe system d .MJ/MJ-MM &&`v&g"i =5&&  k Elsep %Jć%DJJ"JuII="kIIerO"O"v""K!n #oi7ooiiB" // xN'ooo24A//* =0///<<<Z^ jOZ [3 P .*taTЊFsXUoeq??Nome???S0? ??r?h Ba [(rowCounter, col) Leng th = (fieldValuBedIf (t> 100) Then strNamed"Error at line number " & "umn|(,uR& ")" : Father/Husband's Mi ddle (Should beDssan equal to 35 Characs" geW} >= 65537kExit Fun0ctio|End If(Worksheets(").Cells( 4, 1). G= + 1flagၵStopd?'hdis8id(Nome= z" 1 HvalidateGM PublicR JointHoldeB(SRData As StrinLg,@Doeɰ CDim Hi G= s h9 .TextjwF&Eiirijiiiiic,Vrwjuj kaCtRemajs jjÞjjԀԠH LԁQjjj?5~ ?jo??j?j?jB! 45*4P0l?4e93imYesorNo/3h3h,gListAmn;kRow@Range(E).PP0hCol.P > OoPnk:@o On ResuNpe&sinv`Ltgtn0O?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdeg(oHT@@ C 9t/[: ]t/ t (oHT@@ C ?t/ Hi @iq%t: ]/:]/dO : lhXlTlt$Tqq 0,dT4pV:d%%D%t$ Xt $"  a"qx)t 6$(DlxiThk  &^I:d'$lxiT%t$ tqt6$8:d($:T)lxiD:4*6$1'':d+N$$!^i46$d]3N l, q ~o$p<$$t $Kwf%(% X:h'H 8(%$$ $>-A.$6H(pzpz($$H(@PKR(4 %l@DFH%X$ X dD A`1`)XD6Xl@l@DFH%X$ X dD  `1\)XD6 l\0 ^l@($%DFH%X$ X dD  :]3)XD6(@#*#A*#B*1h2pgPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd  ^l@($%DFH%X$ X dD  :]3)XD6(@#*#C*#B*1h2prU~| ##yQ9Y)IYY !)9yI! )IqYI!q qy !"# $1%i%%)%%y9 1%)*9&Y&y&&&&&'9'Y'y''' (**y(Y)- ,,I. 011Q2 4Q566A7633 8)AY9999!:y::;Y;;q///i++ <Q<<<=Q===>A>>>!?I???' @9@i@@@AIBBB DDEF GqGC HHHyJiK LH T T T T T :\l T T T$ T( T, T0 T4 T8 T< T@ T T TD TH TL TP :\L :\< T\ Td 7:$%4:\%8$ 8 d4)84 p;4:\%8$ 8 d4W )845 hU:$ %4:\ %8$ 8 d4= )846U:$%4:\ %8$ 8 d4= )846:\]3 F:%:$%4:\ %8$ 8 d4C)845+''':\N 6A:$%c%4:\ %8$ 8 d4)84:\]3+''':\N 6A:$%c%4:\ %8$ 8 d4)84  p;4:\%8$ 8 d4W )845 h  l+l:\]/p$'5$A:$%c%4:\ %8$ 8 d4)84+''':\N 6pG'':\Nh#*#| *F 2|6A:$%c%4:\ %8$ 8 d4)84H<$<Ll,|84LK7:@%P:T %d$ d dP)dP9c@%P:T %d$ d dP)dPC:@/%P(T%d$ d dP "h)dP5 Xd'T%0h#*F %$ Qdo %P$ P1/P6 J(@%(%P:T %d$ d dP C)dP5 7:@%P:T %d$ d dP)dP:f@%P:T %d$ d dP)dP7:@%P:T %d$ d dP)dP:f@%P:T %d$ d dP)dPL0lh$dP  47:L%\:` %p$ p d\)p\KF<%%p'L%:`!%$ p"tp5ltx")xa :`]36 xq x" c="t c="xA:L%c,%\:` %p$ p d\)p\yE40xt p\XTTTPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd    ^l@($ %DFH%X$ X dD  :]3)XD6@#*#D*1h2pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd  *  ^l@($ %DFH%X$ X dD  :]3)XD6^l@($ %DFH%X$ X dD  :]3)XD68@#*#E*##*#F*1h2 pAPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd  :^l@($ %DFH%X$ X dD  :]3)XD65^l@($ %DFH%X$ X dD  :]3)XD638@#*#E*##*#F*1h2 pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCdKS@#*#G*##*#H*#l`*#I*#B*1h2pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd $ȃŃŃc#ll C :/  #ll C J/  #ll C K/ #ll C L/ ? ;MCNCll C O2  p #ll C P/  _ ; CNCll C Q2El@($ %DFH%X$ X dD )XD%:H]<:4]<'] :NC |l C R` 25  #ll C S/  #ll C T/  #ll C U/ # #ll C V/ȃt ;WCNCll C X2  \MH@ Y1Tl@l@DFH%X$ X dD  l)XD5l(H ]3V0l ;( Z\6\:H[]/\:4\]/\:$]]/L<\:^]/,\:_]/ \:`]/\:a]/\:b]/|\:lc]/\L\:("< Z<6L(H]@eS@#*#G*##*#H*#l`*#I*#h*1h2p PlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd;l\ i j it/6vS@#*#G*##*#H*#l`*#I*#k*1h2p PlhF%p@($%D:H%X$ X dD C)XD5p뫜pCdQS@#*#G*##*#H*#l`*#I*#h*1h2pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCd,S@#*#G*##*#H*#l`*#I*#h*1h2pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCdS@#*#G*##*#H*#l`*#I*#l*1h2pPlhF%p@($%D:H%X$ X dD C)XD5p뫜pCdld00Ŕ 0Ŕ0Ŕ0Ŕ0ŔD0Ŕ04|:H]/$0$,0Ll:]/<,4080 <0@0l(0<64$l<* T0F :HlP\Dl\hl`\ld|!XDL<, |\L, 5H'L% F\%$ Ha8"i(H585H'L% F\%$ Ha8"iH58N(L %l@F\%H$ H d8 A)H58KFl@l@F\%H$ H d8 )Hi @:Lv%:\N%H$ H d8%(%$ w)H58  x_K^@#|*#xG*#t#p*#lH*F8:\I\:LyL<2 |xtpl68\pM<p@(%:\%H$ H d8 C)H58p뫜p :\,,:\]3{ T0 :\lPD,l(,<< |xtplH8\Lt5H'L% F\%$ Ha8"i(H585H'L% F\%$ Ha8"iH58N(L %l@F\%H$ H d8 A)H58KKl@k%F\%H$ H d8 )HFl@l@F\%H$ H d8 )Hi @:Lz%:\N%H$ H d8%(%$ wp)H58 p x0%:\{]/8:L<]<'`Ji @:Lv%:\N%H$ H d8%(%$ wP)H58 P xEK^@#L*#HG*#D#@*#<H*F8:\I`:L|,2 LHD@<68`pMp@(%:\%H$ H d8 C)H58p뫜p :\ +^@#L*#HG*#D#@*#<H*F8:\I`:L|,2 LHD@<68`pMp@(%:\%H$ H d8 C)H58p뫜p :\ 18 ;8:\<]@58/^@#L*#HG*#D#@*#<H*F8:\I`:L|,2 LHD@<68`pMp@(%:\%H$ H d8 C)H58p뫜p :\  :\]3M T0i :\lptL4 l( pP< LHD@<H8`,f.,m%H$ Ha8v"i$%(%4$ @4 >#A$Btl)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468m%H$ Ha8v"i$%(%4$ @4 >#A$Btd)H468m%H$ Ha8v"i$%(%4$ @4 >#A$Bt\)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468m%H$ Ha8v"i$%(%4$ @4 >#A$BtT)H468k%H$ Ha8v"i$%(%4$ @4 >#A$t)H468k%H$ Ha8v"i$%(%4$ @4 >#A$d)H468k%H$ Ha8v"i$%( %4$ @4 >#A$T)H468k%H$ Ha8v"i$%( %4$ @4 >#A$D)H468k%H$ Ha8v"i$%( %4$ @4 >#A$4)H468k%H$ Ha8v"i$%( %4$ @4 >#A$$)H468k%H$ Ha8v"i$%( %4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$)H468k%H$ Ha8v"i$%(%4$ @4 >#A$t)H468k%H$ Ha8v"i$%(%4$ @4 >#A$d)H468olk$]V8olod'olo\'olk]V'ToloT'Dolk]tV4'$olk]dV'olk]TV'olk]DV'olk]4Vt'dolkT]$VD'4olk$]V'olk]V'olk]V'olk]V'tolkd]VT'Dolk4]V$'olk]V'olk]V'olk]V'olkt]Vd'TolkD]tV4'$olk]dV'6 oltt,olk$]V8odk]V'o\k]V'TVD'4oTk]V$'tV'dV'TV'tDVd'D4V4'$V'V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'7 Btt,odolodk$]V8'odo\'odk]V'TodoT'Dodk]tV4'$odk]dV'odk]TV'odk]DV'odk]4Vt'dodkT]$VD'4odk$]V'odk]V'odk]V'odk]V'todkd]VT'Dodk4]V$'odk]V'odk]V'odk]V'odkt]Vd'TodkD]tV4'$odk]dV'6odtt,o\olo\k$]V8'o\od'o\k]V'To\oT'Do\k]tV4'$o\k]dV'o\k]TV'o\k]DV'o\k]4Vt'do\kT]$VD'4o\k$]V'o\k]V'o\k]V'o\k]V'to\kd]VT'Do\k4]V$'o\k]V'o\k]V'o\k]V'o\kt]Vd'To\kD]tV4'$o\k]dV'6o\tt,olk$]V8V'odk]V'To\k]VD'4oTk]V$'tV'dV'TV'tDVd'D4V4'$V'V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV' Btt,oToloTk$]V8'oTod'oTo\'oTk]VT'DoTk]tV4'$oTk]dV'oTk]TV'oTk]DV'oTk]4Vt'doTkT]$VD'4oTk$]V'oTk]V'oTk]V'oTk]V'toTkd]VT'DoTk4]V$'oTk]V'oTk]V'oTk]V'oTkt]Vd'ToTkD]tV4'$oTk]dV'6oTtt,tolk$]V8tV'todk]V'Tto\k]VD'4tV$'toTk]V'tdV'tTV'ttDVd'Dt4V4't$V'tV'tV'tVt'TtVD'$tV'tV'tV'tV'dtVT'4tV$'ttV'tdV'A tBtt,dolk$]V8dV'dodk]V'Tdo\k]VD'4dV$'doTk]V'dtV'dTV'tdDVd'Dd4V4'd$V'dV'dV'dVt'TdVD'$dV'dV'dV'dV'ddVT'4dV$'dtV'ddV' dBtt,Tolk$]V8TV'Todk]V'TTo\k]VD'4TV$'ToTk]V'TtV'TdV'tTDVd'DT4V4'T$V'TV'TV'TVt'TTVD'$TV'TV'TV'TV'dTVT'4TV$'TtV'TdV'  TBtt, Dolk$]V8DV'Dodk]V'TDo\k]VD'4DV$'DoTk]V'DtV'DdV'tDTVd'DD4V4'D$V'DV'DV'DVt'TDVD'$DV'DV'DV'DV'dDVT'4DV$'DtV'DdV'p DBtt, 4olk$]V84V'4odk]V'T4o\k]VD'44V$'4oTk]V'4tV'4dV't4TVd'D4DV4'4$V'4V'4V'4Vt'T4VD'$4V'4V'4V'4V'd4VT'44V$'4tV'4dV' 4Btt, $olk$]V8$V'$odk]V'T$o\k]VD'4$V$'$oTk]V'$tV'$dV't$TVd'D$DV4'$4V'$V'$V'$Vt'T$VD'$$V'$V'$V'$V'd$VT'4$V$'$tV'$dV': $Btt, olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV' Btt, olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV' Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'i Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'! Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'3# Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'$ Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'% Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'b' Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV'( Btt,olk$]V8V'odk]V'To\k]VD'4V$'oTk]V'tV'dV'tTVd'DDV4'4V'$V'V'Vt'TVD'$V'V'V'V'dVT'4V$'tV'dV',* Btt,tolk$]V8tV'todk]V'Tto\k]VD'4tV$'toTk]V'ttV'tdV'ttTVd'DtDV4't4V't$V'tV'tVt'TtVD'$tV'tV'tV'tV'dtVT'4tV$'tV'tdV'+ tBtt,dolk$]V8dV'dodk]V'Tdo\k]VD'4dV$'doTk]V'dtV'ddV'tdTVd'DdDV4'd4V'd$V'dV'dVt'TdVD'$dV'dV'dV'dV'ddVT'4dV$'dV'dtV', dBtt,t<\4$ttddTD/H48TD4$tdD4tTD$dT4$YYYYYYYYYYYYYYYYYYYY0   0   0 P   0   8tTN(( %l@8F<%L$ L d8 A)L85Fl@l@8F<%L$ L d8 )L8(<"P (\lPi(h5(\(<" Z\"lPR6@ m[ m`X m{8 m\"lPp\"lPcx'h\"lPXpH\"lP8c('6X8$  m\"lP35.(\(<" Z6:<]3^@#*#G*##*#H*F: lP\TL8xhXH8(<tTtLN( %l@0F4%D$ D d0 A)D05Fl@l@0F4%D$ D d0 )D0(4"H p(\lHi h5(\(4"| Z|\"lHR6|@ m[| m`L m{, m/ m: m\"lHp\"lH|cl'\\"lHLp<\"lH,c' \"lHp\"lHc'6 |L, @ m[| m`L m{, m\"lHp\"lH|cl'\\"lHLp<\"lH,c' 6|L, oTtTN/ m:| m\"lHp\"lH|cl'\6| oLtLp^@#*#G*##*#H*F:4I|: lx2 6|pMxp@(%0:4%D$ D d0 C)D05p뫜p :4X \~oToL^@#*#G*##*#H*F:4I|: lx2 6|pMxp@(%0:4%D$ D d0 C)D05p뫜p :4XX:4]3 T$$02 :4l/X$<T: lH f\XxlD0|l\L<, tTtLN( %l@0F4%D$ D d0 A)D05Fl@l@0F4%D$ D d0 )D0(4"H pppp(\lHi h5(\(4"x Zx\"lHR6x@ m[x m`H m{( m- m/ m: m\"lHp\"lHxch'X\"lHHp8\"lH(c'\"lH/\"lHp\"lHc'xh6xH(@ m[x m`H m{( m\"lHp\"lHxch'X\"lHHp8\"lH(c'6xH( oTtTN/ m:x m\"lHp\"lHxch'X6xA oLtL$- m\"lH35"\(4]/\/xp kp.(\(4"x ZxX6X:4g]3p^@#T*#PG*#L#H*#DH*F:4Ix: h42 TPLHD6xpWM4p@(%0:4%D$ D d0 C)D05p뫜p :4p^@#T*#PG*#L#H*#DH*F:4Ix: h42 TPLHD6xpKM4p@(%0:4%D$ D d0 C)D05p뫜p :4 \~ oToL^@#T*#PG*#L#H*#DH*F:4Ix: h42 TPLHD6xpPM4p@(%0:4%D$ D d0 C)D05p뫜p :4 kkkk^@#T*#PG*#L#H*#DH*F:4Ix: h42 TPLHD6xpQM4p@(%0:4%D$ D d0 C)D05p뫜p :4:4]3 T0 :4lhX> lHl!\X4xTPLHDD0xhXH8(xhhtTN(( %l@8F<%L$ L d8 A)L85Fl@l@8F<%L$ L d8 )L8(<"P (\lPi(h(5(\(<" Z\"lPR6N/ m: m\"lPp\"lPcx'h6n$. m\"lP353.(\(<" ZX6 oTtTX:<]3<^@#T*#PG*#L#H*#DH*F: lP\X4< TPLHDL8xh0   XN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H<]t^@#*#G*##*#H*F:HI:42 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T((0 :Hl@(l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^@#*#G*##*#H*F:HI:4p2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T,,0 :Hl@(l\`8 XD`N(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^@#*#G*##*#H*F:HI:4q2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 :HPP:H]3 :Hl,D,l\P`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^@#*#G*##*#H*F:HI:4r2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T440 :Hl@(l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^@#*#G*##*#H*F:HI:4s2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T880 :Hl@(l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^@#*#G*##*#H*F:HI:4t2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T<<0 :Hl@(l\`8 XDXN(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H#]t^@#*#G*##*#H*F:HI:4u2 6p6Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T@@0 :Hl@(l\`8 XDx tT c0@N( %l@(F0%,$ , d( A),(5Fl@l@(F0%,$ , d( ),(El@( %(F0%,$ , d( ),( (0]@ f0@"P !(\lPihx5(\(0"h Zh\"lPR6hN/ m:h m\"lPp\"lPhcX'H6h f0@ \~xR@f0]@~ +0]p ]c'hp ,(0'h } h53(0 ]/ ;:~]/h'X5k %(0 ]V(]c'h ;:0]35 f0@k %(0]V(]c'hfB ;:0]/h ;h:]/XH6hUa f0@k %(0]V(]c'h ;:0]35 f0@k %(0]V(]c'h ;:0]35 f0@k %(0]V(]c'hB ;:0]/h ;h:]/XH6h~ f0@k %(0]V(#]c'h ;:0]35 f0@k %(0$]V((]c'h` ;:0]/h ;h:]/XH8 ;8:]/(6h8nz f0@k %(0(]V(-]c'hB ;:0]/h ;h:]/XH6h f0@k %(0-]V(2]c'hO ;:0]/h ;hX X:]/H86hXq} f0@k %(02]V(6]c'h` ;:0]/h ;h:]/XH8 ;8:]/(6h8  f0@k %(08]V(<]c'hr ;:0]35am f0@k %(0<]V(A]c'hB ;:0]/h ;h:]/XH6h f0@k %(0C]V(F]c'h` ;:0]/h ;h:]/XH8 ;8:]/(6h8u f0@k %(0F]V(K]c'h ` ;:0]/h ;h:]/XH8 ;8:]/(6h8   f0@k %(0K]V(N]c'hv  ;:0]35e q  f0@k %(0N]V(O]c'h B ;:0]/h ;h:]/XH6h   f0@k %(0O]V(P]c'h  ;:0]/h ;h:]/XH8 ;8:]/( ;:]/ ;:]/ ;:]/xh6 h8   f0@k %(0P]V(V]c'h_ B ;:0]/h ;h:]/XH6hN Z  f0@k  f0@|  f0@@f0]3n ^@#d*#`G*#\#X*#TH*F:0Ih:XD2 d`\XT6hp MDp@(%(:0%,$ , d( C),(5p뫜p :044:0]3 T0 :0lH \B lxP \@4Dld`\XT,(hXH8(xh0   |N(4 %l@DFH%X$ X dD A)XD5Tl@l@DFH%X$ X dD  )XD5 (H]@(H ]3:H}fH]3^@#*#G*##*#H*F:HI:4p`2 6pgM`p@($%D:H%X$ X dD C)XD5p뫜p :H@^@#*#G*##*#H*F:HI:4p`2 6pMM`p@($%D:H%X$ X dD C)XD5p뫜p :H@@:H]3 THH0 :Hl<H0 l\`@8 XDp(N(4 %l@DFH%X$ X dD A)XD5Fl@l@DFH%X$ X dD )XD %(H]<(4 ]<'-ll C L:H]3/5 :H^@#*#G*##*#H*F:HI:4p2 6pzMpp@($%D:H%X$ X dD C)XD5p뫜p :H:H]3 TPP0 :Hl4(@(l\p8 XDN(4 %l@DFH%X$ X dD A)XD5Fl@l@DFH%X$ X dD )XD (H]@  YTl@l@DFH%X$ X dD  )XD5,:HN 5(H ]30 ;( Z6:H[]/:4\]/:$]]/td:^]/TD:4_]/$:`]/:a]/:b]/:tc]/dT:Dd]/4$:e]/:f]/:Hg((H":4g5>tt(H"d Zd6t(H]@^@#*#G*##*#H*Fp:HI:4ht`2 6p^M`p@($%D:H%X$ X dD C)XD5p뫜p :HPC i j it26^@#*#G*##*#H*Fp:HI:4kt`2 6pM`p@($%D:H%X$ X dD C)XD5p뫜p :HP^@#*#G*##*#H*Fp:HI:4ht`2 6phM`p@($%D:H%X$ X dD C)XD5p뫜p :HP^@#*#G*##*#H*Fp:HI:4ht`2 6pNM`p@($%D:H%X$ X dD C)XD5p뫜p :HP^@#*#G*##*#H*Fp:HI:4lt`2 6p4M`p@($%D:H%X$ X dD C)XD5p뫜p :HPP:H]3 TLL0 :Hl,\Dl\`pPXDtdTD$dT4$PN(4 %l@DFH%X$ X dD A)XD5Fl@l@DFH%X$ X dD )XD (Hd]t^@#*#G*##*#H*F:HI:4t2 6p(Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 :HPP:H]3 :Hl,D,lP\`8 XDPN(4 %l@DFH%X$ X dD A)XD5Fl@l@DFH%X$ X dD )XD (Hd]t^@#*#G*##*#H*F:HI:4t2 6p(Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 :HPP:H]3 :Hl,D,l\P`8 XDLN(4 %l@DFH%X$ X dD A)XD5Fl@l@DFH%X$ X dD )XD (Hd]t^@#*#G*##*#H*F:HI:4t2 6p(Mp@($%D:H%X$ X dD C)XD5p뫜p :H``:H]3 T\\0 :Hl@(l\`8 XD$5H'L% F\%$ Ha8"i(H585H'L% F\%$ Ha8"iH58N(L %l@F\%H$ H d8 A)H58KFl@l@F\%H$ H d8 )Hi @:L%:\N%H$ H d8%(%$ w)H58  x_K^@#|*#xG*#t#p*#lH*F8\:\IL:L<,2 |xtpl68LpM,p@(%:\%H$ H d8 C)H58p뫜p :\:\]3{ T``0 :\l`H0 l\(,< |xtplH8L<      !">`$`$`$`$!`(I`a/0q` y0++<`y0++00<`y0++00$ ` $ `89 `y0++08a `y0++0$ `0` y0++0` y0++0` y0++0)` y0++0Q` y0++0y` y0++0` y0++0` y0++0 ` y0++01` y0++0Y` y0++0` y0++0` y0++0` y0++0` y0++0!` y0++0I` y0++0q` y0++0 ` y0++0!` y0++<"`y0++00n0* pHd VBAProject4@j = r V^ J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE12\MSO.0DLL#M 1@6.0 Ob LibraryKMSFsheet_Activate+Sheets Protectf Sheet2 Sheet3 Sheet4 Sheet5 Module1b(isValidateMandatoryr(isValidCountry (isValidState+(isValidDistrictނ(isValidInvTypenv (isAlphaNumeic(isAlphaNumeic1=E(isIndianPincode'y(isForgienPincodeh(isValidFolioNumber#(isValidDpIdClientIdAccountNop"(isValidInvestorFirstNameL(isValidInvestotMiddleName(isValidInvestorLastName%(isValidFatherHusbandFirstName(isValidFatherHusbandMiddleName(isValidFatherHusbandLastName^ (isNumeric1 (isValidPan(isValidDateOfBirthj(isValidAadharNumber(isValidNomineeNameLength(isValidJointHolderNameLength(isValidRemarksx(isValidInvLtgtn'&(isValidSharesFromUnpaidSuspenseAccount(rowCountu (errorCounter(isPrefillClickedP" isValidAll pisValidJointHolderNameJyisValidNomineeName (Remove_Spaces& Unprotect?Cells (getRowCount strCINTrim@Range strCompanyNamemValueKMsgBoxR WorksheetsPasswordUserInterfaceOnlyN(FindFirstBlankRow sumCalculatee (Calculate (ValidateAllvbOKOnlySumactErrHandlerCalcsumdiv{ Application*Sum rangeSheetW rangeTextRS_ SpecialCellsxlCellTypeConstantsW xlTextValues ClearContents{ ColNumberR colCounter rowCountereDataRow | fieldText fieldValueDisValid@N (validateInvestorMiddleNameLength.%(validateFatherHusbandMiddleNameLength (validatePanv((validateDateOfBirthS(validateAadharNumberj(validateNomineeName(validateJointHolderName~(validateRemarks (alphaNumerica countrynm)UCase5  (indianPincodeflag(foriegnPincode(validateMandatory]LastRowWithValue2FindnSearchDirectionr xlPrevious RowCurrRow (IsBlankRowRowsUmsgQresp vbQuestion vbOKCancelx?vbOK%IsBlanke,xoCount0v SheetDataL%errMsg (validateFolio (alphaNumeric1S(NumericQ(validateCountry#f(validDpIdClientIdAccountNo  (validateState districtName(validateDistrictP(validateInvestorFirstNameLength-(validateInvestorLastNameLength$(validateFatherHusbandFirstNameLength#(validateFatherHusbandLastNameLengthҌ(validateYesorNohvIsDate2cc\ff9]gg_] vbTextCompare Qhh]ii] DateValue/Now%isForiegnPincodeisValidInvestorMiddleName SheetListp}DataListHListRow9ListColColumni countryNamek conNameChkzMatchRIsErrorUstrNameZ stateName2 stateNameChk countryMatch^a  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.6#0#C:\Program Files\Microsoft Office\Office12\EXCEL.EXE#Microsoft Excel 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\system32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.4#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL#Microsoft Office 16.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{9BA372CC-F8E6-403E-8352-B005557D548A}#2.0#0#C:\Users\HIMANS~1\AppData\Local\Temp\Excel8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\G{3050F1C5-98B5-11CF-BB82-00AA00BDCE0B}#4.0#0#C:\Windows\System32\mshtml.tlb#Microsoft HTML Object Library*\G{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}#1.1#0#C:\Windows\System32\ieframe.dll#Microsoft Internet Controls*\G{F5078F18-C551-11D3-89B9-0000F81FE221}#3.0#0#C:\Windows\System32\msxml3.dll#Microsoft XML, v3.0  V^ThisWorkbook01676af27aThisWorkbookf- Sheet10<676af2b9 Sheet1U&  Sheet20=676af2ba3 Sheet20m Sheet30>676af2ba5 Sheet3H Sheet405676af27a7 Sheet4;`Q Sheet506676af27a9 Sheet5Vx-Module10;676af2aa:Module1|H`xb v4IoDJI!jl[EuAKgimgD͔H(ŨbS0S_@蝕(H#DE73HWILkhtwx>A@P02VL:error Excel+ VBAWin16~Win32MacVBA6# VBAProjectstdole`OfficeuMSFormsCMSHTML!xSHDocVw!MSXML2O ThisWorkbook| _Evaluate Sheet1CommandButton1_Click (Prefill_WS1CommandButton2_Click(Validate3PCommandButton3_ClickFA(ClearWork rowColumn1A rowColumn3C rowColumn4D rowColumn6Fcounter ActiveSheet%NxlUp rowColumn2B rowColumn5E rowColumn7G rowColumn8H rowColumn9I rowColumn10_! rowColumn11`! rowColumn12a! rowColumn13b! rowColumn14c! rowColumn15d! rowColumn16e! rowColumn17f! rowColumn18g! rowColumn19h! rowColumn20! rowColumn21! rowColumn22! rowColumn23! rowColumn24!xmlhtp XMLHTTP30 xmlDoc DOMDocument30RgsURL:sEnv strVersion_^setRequestHeader#7sendLoadXMLD responseTextwSelectSingleNodeWstrIncorportaionDated DataColumny>i`arrAlNum fieldNameLengthYChrK~nextvalKacounterncounterspecialCharFlagohypCountE consecutiveFlagu  firstLastHyp (validFolioNO_ validFlagJustatefieldValue~IsPAN fieldValue2invLtgtnE invLtgtnCheckCommandButton1|CommandButton2}CommandButton3~Workbookk WorksheetClickActivate|_B_var_isValidAllu_B_var_isValidJointHolderNameT_B_var_isValidNomineeName _Defaultj _B_var_TrimmT _B_var_strCIN j_B_var_strCompanyName>_B_var_sumCalculate_B_var_rowColumn2_B_var_rowColumn5_B_var_rowColumn7_B_var_rowColumn8_B_var_rowColumn9_B_var_rowColumn10_B_var_rowColumn11_B_var_rowColumn12_B_var_rowColumn13_B_var_rowColumn14_B_var_rowColumn15_B_var_rowColumn16_B_var_rowColumn17_B_var_rowColumn18_B_var_rowColumn19_B_var_rowColumn20_B_var_rowColumn21_B_var_rowColumn22_B_var_rowColumn23_B_var_rowColumn24_B_var_CurrRow _B_var_msgbr _B_var_resp!_B_var_x _B_var_sumdiv$_B_var_DataRow_B_var_fieldText _B_var_fieldValue\_B_var_isValidCB_B_var_countrynm3 _B_var_UCasea _B_var_flagc_B_var_districtNameX _B_var_cco _B_var_Midp _B_var_ff _B_var_gg _B_var_hh- _B_var_iiS_B_var_isForiegnPincode> _B_var_isValidInvestorMiddleName_B_var_fieldName" _B_var_Length> _B_var_Chr\;_B_var_nextval O_B_var_strNameN_B_var_ListRowl=_B_var_ListColj_B_var_countryName_B_var_conNameChkY_B_var_stateName_B_var_stateNameChk +_B_var_countryMatch{%_B_var_statefieldValuew _B_var_LeftQ _B_var_IsPAN _B_var_errMsg`? _B_var_Format_B_var_fieldValue2_B_var_invLtgtng_B_var_invLtgtnCheck 3579;  ~mF`(0!qUadir __SRP_0(__SRP_1PROJECTwm$orms>SFrms3D452EE1-E08F`A-8-02608C@4D0BB4SFM20L'B _&/;"1jIqAHq00}#0Bq# 50 A9BA372CC-F8E6-403E-8352-B005557D548A6Users\HIMANS~1\AppData\Local\Temp\Excel8.0@d8.exdHe=#.E .``M CMSHTMLCMiHTML@v lA33050F1C5-98B5-11CF-BB82DBDC@E0B}#4MSEmshtmlXSHDocVw#HSHDAFcVwukEAB22AC0-30C1!A7EB9C05BA1.1Kriefbe.dll*Internet Contprols @&XML2&Xb&2 !&b&F5078F18-C55D3-89B9F81FE221}#3&xml3, v E@ThisWorkbookGTTioWA(rkboU2` 11-"a,f")+Sheet1G Set162 U&U 2 2 2 2 m 3 3 3 3 4 4 4 4 Q T; 5 5 5 5 EV d`odule#doyuy!#2$f _^*|!X*rU~~~y   CurrRow SheetData rowCounter colCounter SheetL RangeText G2   Value Please enter CINPasswordFF "UserInterfaceOnlyProtect 6Please Prefill Company Name Stop 2Error! Please refer Error @Invalid data present at row no:: 2 .Kindly refer ErrorSheet)VBE6.DLL   S ( A15:O65536$Ovn$C @EndRow * : pBlank Rows Found.Do you want to Clear Rows from row no.   to  ??? *Deletion ConfirmationClearContentsSpecialCells Count A1 O10:OSum INDIA  Column   x *Error at line number  \ column 1 or 3 (Investor First or Last Name) $ : Mandatory Field l column 4 or 6 (Father/Husband's First or Last Name)  p column 10 or 11 either District or Pincode is mandatory$ Either Folio Number or DP Id-Client Id-Account Number is mandatory  column  ( ) Sheet3 A2 InvestmentLtgtn JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC - MEGHALAYA , : Invalid Date Format f : should be less than or equal to the system date.  : Invalid Date -  x    "  MAHARASHTRA MADHYA PRADESH b : More than one consecutive space is not allowed r : Special Characters and Numeric Values are not allowed. ` $ : Investor First Name Should be Less Than or equal to 35 Characters GUJARAT DAMAN AND DIU GOA$ : Investor Middle Name Should be Less Than or equal to 35 Characters# : Investor Last Name ShoK*rU ~~~~~~~~~~ ~~~~~~~~~~~~~~~~ bR(I0 d   a q Aa YA)a YAA Y qa # 9 Y  ! 9 a 1 y i9a 9qAQiiiI )  VBAProject ThisWorkbookSheet1Sheet2Sheet3Sheet4Sheet5Module1F /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  10F4C:\Program Files\Microsoft Office\Office12\EXCEL.EXEExcel 9@0FvalidateDistrictC:\Windows\system32\stdole2.tlbstdole  QPL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLLOffice q`.E .`M C:\Windows\system32\FM20.DLLMSForms  Qpr>@RU}T9C:\Users\HIMANS~1\AppData\Local\Temp\Excel8.0\MSForms.exd QP0  Prefill_WS1C:\Windows\System32\mshtml.tlbMSHTML  Q*0[ C:\Windows\System32\ieframe.dllSHDocVw 1 Q!C:\Windows\System32\msxml3.dllMSXML2   Validate Calculate Remove_Spaces ValidateAllFindFirstBlankRow IsBlankRowvalidateMandatoryvalidateCountry validateState getRowCounterrorClear alphaNumeric validateFolio alphaNumeric1Numeric validFolioNOvalidDpIdClientIdAccountNovalidateInvestorFirstNameLength  validateInvestorMiddleNameLengthvalidateInvestorLastNameLength $validateFatherHusbandFirstNameLength %validateFatherHusbandMiddleNameLength #validateFatherHusbandLastNameLength indianPincodeforiegnPincode validatePanvalidateAadharNumbervalidateDateOfBirthvalidateNomineeNamevalidateJointHolderNamevalidateRemarksvalidateYesorNo tt  $(,048<@DHLPTX\`dF gB݆ Fl=8EMThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3Sheet4Sheet4Sheet5Sheet5Module1Module1ID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkboPROJECT 'KSummaryInformation("5DocumentSummaryInformation898 CompObj frok/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Document=Sheet4/&H00000000 Document=Sheet5/&H00000000 Module=Module1 HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="FBF9575E5662566253675367" DPB="F6F45A5BAEADB4CAB4CA4B36B5CA78DC290EEE28979A3325DC37136DB7C315A9374F6FC24BD28A" GC="F1F35D9E5E9E5E9E" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 &H00000002={00020818-0000-0000-C000-000000000046};Excel8.0;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=130, 130, 1024, 571, Z Sheet2=182, 182, 1076, 623, Sheet3=208, 208, 1102, 649, Z Sheet4=156, 156, 1050, 597, Sheet5=26, 26, 920, 467, C Module1=52, 52, 946, 493, Z Oh+'0@Hdx Natasha Bhagwani himanshusdMicrosoft Excel@@,V՜.+,D՜.+,t0 PXp x Infosys Limited 7Read MeInvestor DetailsErrorSheet3Country_State_District_MappingAndamanandNicobarIslandsAndhraPradeshArunachalPradeshAssamBihar Chandigarh ChhattisgarhCountryDadarNagarHaveli DamanandDiuDelhiGoaGujaratHaryanaHimachalPradeshIndiaInvestment_LitigationInvestmentLitigatioInvestmentLitigationInvestmentLtgInvestmentTypeJammuandKashmir Jharkhand KarnatakaKerala LakshadweepMadhyaPradesh MaharashtraManipur MeghalayaMizoramNA NagalandOrissa PondicherryPunjab Rajasthansfsfusa%shares_from_unpaind_suspense_account sharesfusaSikkimsssss TamilNadu TelanganaTripura Uttarakhand UttarPradesh WestBengal  Worksheets Named Ranges2!5e y    )Y8MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_Enabled7MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_SiteId6MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_Owner8MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_SetDate5MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_Name<MSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_ApplicationEMSIP_Label_be4b3411-284d-4d31-bd4f-bc13ef7f1fd6_Extended_MSFT_Method 8MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_Enabled 7MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_SiteId 6MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_Owner 8MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_SetDate 5MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_Name<MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_Application7MSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_ParentEMSIP_Label_a0819fa7-4367-4500-ba88-dd630d977609_Extended_MSFT_Method SensitivityTrue(63ce7d59-2f3e-42cd-a8cc-be764cff5eb6$saisrinivas.bollina@ad.infosys.com 2019-02-25T07:10:45.2162424Z Internal(Microsoft Azure Information Protection AutomaticTrue(63ce7d59-2f3e-42cd-a8cc-be764cff5eb6$saisrinivas.bollina@ad.infosys.com 2019-02-25T07:10:45.2162424ZCompanywide usage(Microsoft Azure Information Protection(be4b3411-284d-4d31-bd4f-bc13ef7f1fd6 AutomaticInternal Companywide usage F&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.89q